![96f3b6c7579d86f4839e54a9b0846254.gif](https://i-blog.csdnimg.cn/blog_migrate/7baff6b48d19011fdd57219c36cfea5a.gif)
点击关注,我们共同每天进步一点点!
1 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)
2 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)
原文地址:
https://www.cnblogs.com/Yunya-Cnblogs/p/13585848.html
![f0e4b815f08cf37b47807dbe8ed40783.png](https://i-blog.csdnimg.cn/blog_migrate/304eeb02fc6ea6c2fbb38c31613a5bd8.jpeg)
![100ddfac8238b23b370f9b95af37742c.gif](https://i-blog.csdnimg.cn/blog_migrate/9cd8c1ca286119bec9291841e08b6501.gif)
喜欢请关注,有用请转发~
升职、加薪、无漏测-点“在看”
![4c1f6e3050e50372c86b233ef95d074f.gif](https://i-blog.csdnimg.cn/blog_migrate/e7fff901c9da4ccf59156372f13d3f1a.gif)