oj-sql

题目

SQL111 插入记录（三）

思路

1. 替换插入语句；

solution

replace into

replace into examination_info (exam_id,tag,difficulty,duration,release_time)
values (9003,'SQL','hard',90,'2021-01-01 00:00:00');

先delete再insert

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