SET Type : Set « Data Types « MySQL Tutorial

1. MySQL Tutorial
2. Data Types
3. Set

The SET type stores a list of values.

A SET is a string object that can have zero or more values.

In a SET type, you can choose more than one option to store.

A SET type can contain up to 64 items.

Each of which must be chosen from a list of values.

Multiple set members are separated by commas (',').

SET member values should not contain commas.

mysql>
mysql>
mysql> CREATE Table Test(
    ->     Advertiser SET('A','B','C')
    -> );
Query OK, 0 rows affected (0.03 sec)

mysql>
mysql>
mysql> INSERT INTO Test (Advertiser) values('A, B');
Query OK, 1 row affected, 1 warning (0.00 sec)

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

mysql>