Mega Code Archive

 

Categories / MySQL / Data Type

 

The SET datatype, like ENUM, is declared using a comma-separated list of quoted strings that define its valid

members. mysql> mysql> CREATE TABLE allergy     -> (     ->     symptom SET('sneezing','runny nose','stuffy head','red eyes')     -> ); Query OK, 0 rows affected (0.01 sec) mysql> mysql> drop table allergy; Query OK, 0 rows affected (0.00 sec) mysql> mysql>