一个trigger trigger的错误

晚上想更新一下数据,没想到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