晚上想更新一下数据,没想到insert了两条数据就报错:
ERROR 1062: Duplicate entry ‘1’ for key ‘PRIMARY’ SQL Statement
怎么检查都没有查到有重复的主键,只好瞎子抹黑一样逐个alter表格的属性,直到删除了前几天设置的一个trigger,这个错误才排除
=============== TRIGGER CODE ================
— Trigger DDL Statements
DELIMITER $$
USE `db_chyujian`$$
CREATE
DEFINER=`root`@`localhost`
TRIGGER `db_chyujian`.`ins_test`
AFTER INSERT ON `db_chyujian`.`buchhaltung_chyujian`
FOR EACH ROW
begin
insert into monatliche_statistik(id, monat, Total, total_ausflug,
total_bildung, total_nahrung, total_andere)
values(1, 10, new.betrag, 0, 0, 0, 0);
end$$
=============== RELEVANT BLOG ================
http://www.tripsina.com/?p=1522
Recent Comments