枚举与集合类型

注意:()内必须是字符串类型

枚举 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)