ENUM
枚举类型从众多选项中提取出一个选项,类似于单选的概念,最大可指定65535个选项。
如果插入值不在其选项中,将会插入。
mysql> create table user( # 创建用户表
-> name char(12),
-> gender enum("male","famale","outher"), # 性别使用枚举类型再合适不过
-> age tinyint
-> );
Query OK, 0 rows affected (0.04 sec)
mysql> insert into user(name,gender,age) values
-> ("Yunya","male",18),
-> ("Baby","famale",18);
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> select * from user;
+--------------+--------+------+
| name | gender | age |
+--------------+--------+------+
| Yunya | male | 18 |
| Baby | famale | 18 |
+--------------+--------+------+
2 rows in set (0.00 sec)
mysql>
SET
集合类型从众多选项中提取出多个选项,类似于多选的概念,最大可指定64个选项。
如果插入值中有一个不在其选项中,该插入值将为,在其选项中的值将会正确插入。
mysql> create table user( # 创建用户表
-> name char(12),
-> gender enum("male","famale","outher"),
-> age tinyint,
-> hobby set("basketball","football","music","playgame") # 爱好使用集合类型再合适不过
-> );
Query OK, 0 rows affected (0.03 sec)
mysql> insert into user(name,gender,age,hobby) values
-> ("Yunya","male",18,"basketball,playgame"),
-> ("Baby","famale",18,"football,music"); # 插入时按照 "选项1,选项2" 的方式进行插入
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> select * from user;
+--------------+--------+------+---------------------+
| name | gender | age | hobby |
+--------------+--------+------+---------------------+
| Yunya | male | 18 | basketball,playgame |
| Baby | famale | 18 | football,music |
+--------------+--------+------+---------------------+
2 rows in set (0.00 sec)
mysql>