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

Question

红色的那句请大家帮修改下
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
beinginsert 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
?

Answer 1

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

Answer 2

那你还是自己写在操作系统的脚本中吧。 MYSQL中不支持这种语法，IF只能放在存储过程中执行。