注意:()内必须是字符串类型
枚举 enum('a','b','c','d') 多选一
集合 set('a','b','c','d') 多选多
示例:
# 员工信息表
create table emp(
id int primary key auto_increment,
name varchar(15),
sex enum('male','female','unknown'),
hobbies set('read','music','eat','play')
);
insert into emp values
(01,'hgq','male','read,music'),
(02,'hhh','1','1');
mysql> create table emp(
-> id int primary key auto_increment,
-> name varchar(15),
-> sex enum('male','female','unknown'),
-> hobbies set('read','music','eat','play')
-> );
Query OK, 0 rows affected (0.03 sec)
mysql> desc emp;
+---------+----------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+----------------------------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(15) | YES | | NULL | |
| sex | enum('male','female','unknown') | YES | | NULL | |
| hobbies | set('read','music','eat','play') | YES | | NULL | |
+---------+----------------------------------+------+-----+---------+----------------+
4 rows in set (0.01 sec)
mysql> insert into emp values
-> (01,'hgq','male','read,music'),
-> (02,'hhh','1','1');
Query OK, 1 row affected (0.01 sec)
mysql> select * from emp;
+----+------+------+------------+
| id | name | sex | hobbies |
+----+------+------+------------+
| 1 | hgq | male | read,music |
| 2 | hhh | male | read |
+----+------+------+------------+
2 rows in set (0.00 sec)
网友评论