SQL1 插入记录（一）

牛客网打卡：SQL1 插入记录（一）

解题思路

使用 insert into 函数即可

代码

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);
insert into 
    exam_record (uid, exam_id, start_time, submit_time, score) 
    values(1002,9002,'2021-09-04 07:01:02',NULL,NULL);

– 或者

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);