enum数据类型 mysql_mysql 数据类型之enum / set

mysql> select database();      -- 查询当前数据库

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

| database() |

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

| pymysql |

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

1 row in set (0.00 sec)

mysql>

mysql> select user();   -- 查询当前会话的登陆用户

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

| user() |

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

| root@localhost |

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

1 row in set (0.00 sec)

mysql>

mysql> show processlist;      -- 查看哪些用户登陆了数据库服务器

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

| Id | User | Host | db | Command | Time | State | Info |

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

| 46 | root | localhost | pymysql | Query | 0 | starting | show processlist |

| 57 | root | 192.168.85.1:3485 | day43 | Sleep | 136 | | NULL |

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

2 rows in set (0.00 sec)

mysql>

mysql> create table user2 (

id int auto_increment primary key,

name varchar(20) unique not null,

gender enum('male',"female") deefault 'male',

age tinyint(3),

hobby set("喝酒","吃烟","泡妞","打游戏","旅游")

) engine=innodb default charset='utf8';

Query OK,0 rows affected (0.08sec)

mysql>describe user2;+--------+------------------------------------------------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

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

| id | int(11) | NO | PRI | NULL | auto_increment |

| name | varchar(20) | NO | UNI | NULL | |

| gender | enum('male','female') | YES | | male | |

| age | tinyint(3) | YES | | NULL | |

| hobby | set('喝酒','吃烟','泡妞','打游戏','旅游') | YES | | NULL | |

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

5 rows in set (0.00sec)

mysql> insert into user2 (name,age,hobby) values('nezha',27,'旅游,吃烟,喝酒')->;

Query OK,1 row affected (0.00sec)

mysql> select * fromuser2;+----+-------+--------+------+----------------------+

| id | name | gender | age | hobby |

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

| 1 | nezha | male | 27 | 喝酒,吃烟,旅游 |

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

1 row in set (0.01sec)

mysql>