mysql插入语句(insert)

语法1

insert into 表名(列名,...) values(值1,...);

实例

insert into student(`name`,`sex`,`age`,`class_id`,`status`) values('胡勇健','男',28,1,1);

Query OK, 1 row affected (0.01 sec)

实例

insert into student(`name`,`sex`,`age`,`class_id`,`status`) 
values('胡勇健1','男',28,1,1),('胡勇健2','男',30,1,1),('胡勇健3','男',31,1,1);

Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

语法2

insert into 表名
set 列名1=值1, 列名2=值2...

实例

insert into student
set `name`='HuYongJian',`sex`='男',`age`=30,`class_id`=1,`status`=1;