1 '''
2 t_student表结构
3 +--------+------------------------+------+-----+---------+----------------+
4 | Field | Type | Null | Key | Default | Extra |
5 +--------+------------------------+------+-----+---------+----------------+
6 | id | int(10) unsigned | NO | PRI | NULL | auto_increment |
7 | name | varchar(30) | YES | | NULL | |
8 | age | tinyint(3) unsigned | YES | | 0 | |
9 | gender | enum('男','女','保密') | YES | | 保密 | |
10 | cls_id | int(10) unsigned | YES | | NULL | |
11 | birth | date | YES | | NULL | |
12 +--------+------------------------+------+-----+---------+----------------+
13 '''
14 -- 每个字段都插入数据
15 -- auto_increment可以用0,null,default表示,不能不写
16 -- enum('男','女','保密')可以用数据1,2,3对应表示
17 INSERT INTO t_student VALUES(0,'小李飞刀',20,'女',1,'1990-1-1');
18 INSERT INTO t_student VALUES(null,'小李飞刀',20,'女',1,'1990-1-1');
19 INSERT INTO t_student VALUES(default,'小李飞刀',20,'女',1,'1990-1-1');
20
21 -- 指定列添加数据
22 INSERT INTO t_student (name,gender) VALUES('小法1',1),('小法2',1);