红色的那句请大家帮修改下

红色的那句请大家帮修改下




if (select count(*) from triggers where name='trg_pos_machine_insert') > 0
drop trigger trg_pos_machine_insert;
create trigger trg_pos_machine_after_insert  
AFTER INSERT
on pos_machine  
for each row
being

insert into pos_receivedate(posno,itemno)
values( @posno,"会员资料");

insert into pos_receivedate(posno,itemno)
values( @posno,"商品条码");

insert into pos_receivedate(posno,itemno)
values( @posno,"商品资料");

insert into pos_receivedate(posno,itemno)
values( @posno,"店促商品");

insert into pos_receivedate(posno,itemno)
values( @posno,"店促档期");

insert into pos_receivedate(posno,itemno)
values( @posno,"DM商品");

insert into pos_receivedate(posno,itemno)
values( @posno,"DM档期");

insert into pos_receivedate(posno,itemno)
values( @posno,"员工资料");
end
?

SELECT COUNT(*) INTO @aa FROM `information_schema`.`TRIGGERS` a WHERE a.`TRIGGER_NAME`='trg_pos_machine_insert' AND a.`TRIGGER_SCHEMA`='aa';
IF @aa<=0 THEN
....

无法动态创建TRIGGER