1.insert into
用于向表中插入行记录
#向examination_info表中插入一行记录,此处如果表中已有key为9003的记录,该插入操作将执行失败
insert into examination_info
values(null,9003,'SQL','hard',90,'2021-01-01 00:00:00')
2.replace into
用于向表中带更新地插入
(replace into 检测到主键或唯一性索引键重复就删除原记录后重新插入)
法一:
#无论表中是否已有有key为9003的记录,都会执行插入操作,如果表中已有key为9003的记录,则先删除该记录,然后执行插入操作
replace into examination_info
values(null,9003,'SQL','hard',90,'2021-01-01 00:00:00')
法二:
delete from examination_info
where exam_id=9003;
insert into examination_info
values(null,9003,'SQL','hard',90,'2021-01-01 00:00:00')