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语句只是测试用的。请问问题出在哪儿
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语句只是测试用的。请问问题出在哪儿
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给删了,反而能执行了 但是使用过程中又出错 极其郁闷
但是执行过程中会出现重复调用的错误
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 ;
FOR EACH ROW
insert into itop_info.ipinterface_test(interfaceid,interfacename,devicename,ip) values('100','test','test','1.1.1.1');