在MYSQL数据库中创建触发器总是报语法错误

[bamboocaidao]

CREATE TRIGGER itop_physical_insert after insert ON itop_info.ipinterface
FOR EACH ROW
BEGIN
insert into itop_info.ipinterface_test(interfaceid,interfacename,devicename,ip) values('100','test','test','1.1.1.1')
END;


总是报错说END附近有语法错误。本insert语句只是测试用的。请问问题出在哪儿

[yo_yo1120]

insert语句句末加上分号试试。

[bamboocaidao]

引用 1 楼 u010581018 的回复:

insert语句句末加上分号试试。

加了没用 加了之后就显示空格处有语法错误 蛋疼，，，

[Rotel-刘志东]

CRREATE TRIGGER itop_physical_insert after insert on itop_info.ipinterface for each row BEGIN insert into itop_info.ipinterface_test(interfaceid,interfacename,devicename,ip) values('100','test','test','1.1.1.1'); END;

[bamboocaidao]

引用 3 楼 lzd_83 的回复:

CRREATE TRIGGER itop_physical_insert after insert on itop_info.ipinterface for each row BEGIN insert into itop_info.ipinterface_test(interfaceid,interfacename,devicename,ip) values('100','test','test','1.1.1.1'); END;

还是报错 我现在直接把beginend给删了，反而能执行了 但是使用过程中又出错 极其郁闷

[yo_yo1120]

我是Mysql5.5，加上分号就正常的。

[bamboocaidao]

现在我把begin和end给删除了。。。居然就可以执行了。。。 但是执行过程中会出现重复调用的错误

[wwwwb]

delimiter $$ CREATE TRIGGER itop_physical_insert after insert ON itop_info.ipinterface FOR EACH ROW BEGIN insert into itop_info.ipinterface_test(interfaceid,interfacename,devicename,ip) values('100','test','test','1.1.1.1') END;$$ delimiter ;

[ACMAIN_CHM]

CREATE TRIGGER itop_physical_insert after insert ON itop_info.ipinterface FOR EACH ROW insert into itop_info.ipinterface_test(interfaceid,interfacename,devicename,ip) values('100','test','test','1.1.1.1');