Python-4.39 数据库枚举类型与集合类型

mysql> create table consumer(
    -> id int,
    -> name char(16),
    -> sex enum('male','female','other'),
    -> level enum('vip1','vip2','vip3'),
    -> hobbies set('play','music','read','run')
    -> );
Query OK, 0 rows affected (0.23 sec)


mysql> insert into consumer values
    -> (1,'winnie','male','vip2','music,read');
Query OK, 1 row affected (0.04 sec)


mysql> insert into consumer values
    -> (1,'allen','xxxxx','vip2','music,read');
ERROR 1265 (01000): Data truncated for column 'sex' at row 1


mysql> select * from consumer;
+------+--------+------+-------+------------+
| id   | name   | sex  | level | hobbies    |
+------+--------+------+-------+------------+
|    1 | winnie | male | vip2  | music,read |
+------+--------+------+-------+------------+
1 row in set (0.00 sec)