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

# 解法一:使用delete from 语句先删除表中需要重新插入的那一行内容；再使用insert into 语句将内容插入进入
/*
delete from examination_info where exam_id = 9003;
insert into examination_info(exam_id,tag,difficulty,duration,release_time) VALUES (9003,"SQL","hard",90,"2021-01-01 00:00:00")
*/

# 解法二：直接使用replace into语句，尝试插入数据到表中。
replace into examination_info values 
(null,9003,"SQL","hard",90,"2021-01-01 00:00:00")