SET column type : Set « Data Types « MySQL Tutorial

1. MySQL Tutorial
2. Data Types
3. Set

mysql>
mysql> CREATE TABLE myTable
    -> (
    ->    ID SMALLINT UNSIGNED,
    ->    Model VARCHAR(40),
    ->    Color ENUM('red', 'blue', 'green', 'yellow'),
    ->    Options SET('rack', 'light', 'helmet', 'lock')
    -> );
Query OK, 0 rows affected (0.03 sec)

mysql>
mysql> desc myTable;
+---------+-------------------------------------+------+-----+---------+-------+
| Field   | Type                                | Null | Key | Default | Extra |
+---------+-------------------------------------+------+-----+---------+-------+
| ID      | smallint(5) unsigned                | YES  |     | NULL    |       |
| Model   | varchar(40)                         | YES  |     | NULL    |       |
| Color   | enum('red','blue','green','yellow') | YES  |     | NULL    |       |
| Options | set('rack','light','helmet','lock') | YES  |     | NULL    |       |
+---------+-------------------------------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql>
mysql> drop table myTable;
Query OK, 0 rows affected (0.02 sec)