1.表中插入数据
格式:insert into 表名(列名1,列名2,列名3) values(对应值1,对应值2,对应值3);
注意:可以选择相应的列名,插入相应的值。
insert into student(sid,sname,sex,age) values(1,"zhangsan",1,23);
简单写法:insert into 表名 values(对应值1,对应值2,对应值3);
注意:省略列名时,默认对全部列名的表插入值。
insert into student values(1,"zhangsan",1,23);
查看表中的数据:
select *from student;
批量插入数据:
insert into student values
(2,"zhangsan",1,23),
(3,"zhangsan",1,23),
(4,"zhangsan",1,23),
(5,"zhangsan",1,23),
(6,"zhangsan",1,23);
结果: