题解 | #插入记录（一）#

方式一
# insert into exam_record(uid,exam_id,start_time,submit_time,score) 
# values(1001,9001,'2021-09-01 22:11:12','2021-09-01 23:01:12',90),
# (1002,9002,'2021-09-04 07:01:02',null,null);
方式二
insert into exam_record values(null,1001,9001,'2021-09-01 22:11:12','2021-09-01 23:01:12',90),(null,1002,9002,'2021-09-04 07:01:02',null,null);

insert into 表名（列名）values（列值）,（列值）;

inesrt into values（列值）,（列值）；

insert into 表名（列名）select 字段名，字段名 from 表名

insert into 表名 select * from 表名