如果原表有重复数据,需要先删除,不然会出现重复数据
方法一:
insert into examination_info(exam_id,tag,difficulty,duration,release_time)
VALUES('SQL','hard', 90, '2021-01-01 00:00:00')
方法二:
DELETE FROM examination_info
WHERE exam_id=9003;
INSERT INTO examination_info
VALUES(NULL, 'SQL','hard', 90, '2021-01-01 00:00:00')



京公网安备 11010502036488号