Syntax
SET('value1','value2',...) [CHARACTER SET charset_name] [COLLATE collation_name]Description
A set. A string object that can have zero or more values, each of which must be chosen from the list of values 'value1', 'value2', ... A SET column can have a maximum of 64 members. SET values are represented internally as integers.
SET values cannot contain commas.
If a SET contains duplicate values, an error will be returned if strict mode is enabled, or a warning if strict mode is not enabled.
See Also
- Character Sets and Collations
- Data Type Storage Requirements
- ← VARCHAR
- ↑ String Data Types ↑
- UUID Data Type →
Comments
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
Set data types: set, frozenset
1. Python Numeric Data Type
Python numeric data type is used to hold numeric values like;
- int - holds signed integers of non-limited length.
- long- holds long integers(exists in Python 2.x, deprecated in Python 3.x).
- float- holds floating precision numbers and it’s accurate up to 15 decimal places.
- complex- holds complex numbers.
In Python, we need not declare a datatype while declaring a variable like C or C++. We can simply just assign values in a variable. But if we want to see what type of numerical value is it holding right now, we can use type(), like this:
#create a variable with integer value. a=100 print("The type of variable having value", a, " is ", type(a)) #create a variable with float value. b=10.2345 print("The type of variable having value", b, " is ", type(b)) #create a variable with complex value. c=100+3j print("The type of variable having value", c, " is ", type(c))If you run the above code you will see output like the below image.
2. Python String Data Type
The string is a sequence of characters. Python supports Unicode characters. Generally, strings are represented by either single or double-quotes.
a = "string in a double quote" b= 'string in a single quote' print(a) print(b) # using ',' to concatenate the two or several strings print(a,"concatenated with",b) #using '+' to concate the two or several strings print(a+" concated with "+b)The above code produces output like the below picture-
3. Python List Data Type
The list is a versatile data type exclusive in Python. In a sense, it is the same as the array in C/C++. But the interesting thing about the list in Python is it can simultaneously hold different types of data. Formally list is an ordered sequence of some data written using square brackets([]) and commas(,).
The above code will produce output like this-
4. Python Tuple
The tuple is another data type which is a sequence of data similar to a list. But it is immutable. That means data in a tuple is write-protected. Data in a tuple is written using parenthesis and commas.
#tuple having only integer type of data. a=(1,2,3,4) print(a) #prints the whole tuple #tuple having multiple type of data. b=("hello", 1,2,3,"go") print(b) #prints the whole tuple #index of tuples are also 0 based. print(b[4]) #this prints a single element in a tuple, in this case "go"The output of this above python data type tuple example code will be like the below image.
5. Python Dictionary
Python Dictionary is an unordered sequence of data of key-value pair form. It is similar to the hash table type. Dictionaries are written within curly braces in the form key:value. It is very useful to retrieve data in an optimized way among a large amount of data.
#a sample dictionary variable a = {1:"first name",2:"last name", "age":33} #print value having key=1 print(a[1]) #print value having key=2 print(a[2]) #print value having key="age" print(a["age"])If you run this python dictionary data type example code, the output will be like the below image.