Mega Code Archive
SET Type
<![CDATA[
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> CREATE Table Test(
-> Advertiser SET('A','B','C')
-> );
Query OK, 0 rows affected (0.03 sec)
mysql>
mysql> INSERT INTO Test (Advertiser) values('A, B');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql>
mysql> drop table Test;
Query OK, 0 rows affected (0.02 sec)
mysql>
]]>