SET: Combination of up to 255 strings : Set « Data Type « SQL / MySQL






  1. SQL / MySQL
  2. Data Type
  3. Set

SET: Combination of up to 255 strings

   
mysql>
mysql> CREATE TABLE employee(
    ->     id INT,
    ->     eName VARCHAR(10),
    ->     flags SET("a","b","c")
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> drop table employee;
Query OK, 0 rows affected (0.00 sec)

mysql>








Related examples in the same category

1.Use SET to have arbitrary combinations
2.Set multiple values
3.To identify SET values that share common elements
4.To break down a set of observations and show each count as a percentage of the total
5.Select only one value among the set