题解 | #插入记录(三)#
插入记录(三)
https://www.nowcoder.com/practice/978bcee6530a430fb0be716423d84082
# 解法一:使用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")
