mysql 数据类型枚举类型与集合类型

字段的值只能在给定范围中选择，如单选框，多选框

enum 单选只能在给定的范围内选一个值，如性别 sex 男male/女female

set 多选在给定的范围内可以选择一个或一个以上的值（爱好1,爱好2,爱好3...）

sex enum('male','female')

hobby set('run','tennis','read','football')

mysql> create table consumer(

    -> id int,

    -> name varchar(16),

    -> sex enum('male','female'),

    -> level enum('vip1','vip2','vip3'),

    -> hobby set('run','tennis','read','football')

    -> );

Query OK, 0 rows affected (0.01 sec)

插入一条记录

mysql> insert into consumer values(1,'mike','male','vip1','run,read');

Query OK, 1 row affected (0.00 sec)

mysql> select * from consumer;

+------+------+------+-------+----------+

| id   | name | sex  | level | hobby    |

+------+------+------+-------+----------+

|    1 | mike | male | vip1  | run,read |

+------+------+------+-------+----------+

1 row in set (0.00 sec)

插入一条记录时在sex字段插入一个不是 male或者female的字段没有报错

不在范围之内的最后查询是空的

mysql> insert into consumer values(2,'mike','ssadasd','vip2','tennis,football');

Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> select * from consumer;

+------+------+------+-------+-----------------+

| id   | name | sex  | level | hobby           |

+------+------+------+-------+-----------------+

|    1 | mike | male | vip1  | run,read        |

|    2 | mike |      | vip2  | tennis,football |

+------+------+------+-------+-----------------+

2 rows in set (0.00 sec)

巴特西

mysql 数据类型枚举类型与集合类型

最新文章

热门文章

巴特西

mysql 数据类型 枚举类型与集合类型

最新文章

热门文章

mysql 数据类型枚举类型与集合类型