牛客437569835号

题解

/ 注册

全部文章 / 题解（共3篇）

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

DELETE FROM examination_info WHERE exam_id=9003; INSERT INTO examination_info (exam_id, tag, difficulty, duration, release_time) VALUES(9003, "SQL","h...

Mysql

2021-10-19

1 472

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

INSERT INTO exam_record_before_2021 (uid, exam_id, start_time, submit_time, score) SELECT uid, exam_id, start_time, submit_time, score FROM exam_recor...

Mysql

2021-10-19

0 471

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

INSERT INTO exam_record(id, uid, exam_id, start_time, submit_time, score) VALUES(DEFAULT, 1001, 9001, "2021-09-01 22:11:12", "2021-09-01 23:01:12",90)...

Mysql

2021-10-19

1 1219