mysql> create table data(id int not null auto_increment primary key,
-> name varchar(20),sex enum("男生","女生"));
Query OK, 0 rows affected (0.05 sec)mysql> insert into data values('1','王小明','男生');
Query OK, 1 row affected (0.01 sec)mysql> select * from data;
+----+--------+------+
| id | name | sex |
+----+--------+------+
| 1 | 王小明 | 男生 |
+----+--------+------+
1 row in set (0.05 sec)mysql> insert into data values('2','张小丽','女生');
Query OK, 1 row affected (0.00 sec)mysql> select * from data;
+----+--------+------+
| id | name | sex |
+----+--------+------+
| 1 | 王小明 | 男生 |
| 2 | 张小丽 | 女生 |
+----+--------+------+
2 rows in set (0.00 sec)mysql>
-> name varchar(20),sex enum("男生","女生"));
Query OK, 0 rows affected (0.05 sec)mysql> insert into data values('1','王小明','男生');
Query OK, 1 row affected (0.01 sec)mysql> select * from data;
+----+--------+------+
| id | name | sex |
+----+--------+------+
| 1 | 王小明 | 男生 |
+----+--------+------+
1 row in set (0.05 sec)mysql> insert into data values('2','张小丽','女生');
Query OK, 1 row affected (0.00 sec)mysql> select * from data;
+----+--------+------+
| id | name | sex |
+----+--------+------+
| 1 | 王小明 | 男生 |
| 2 | 张小丽 | 女生 |
+----+--------+------+
2 rows in set (0.00 sec)mysql>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货