-> end;// -> delimiter ;或者简单一点：mysql> delimiter // -> create trigger sitedata_ins2 -> before insert on user -> for each row -> Begin -> insert into user_data(d_id,d_name) values(new.id,new.name);-> end;// -> delimiter ;二种方法都可以，建议你用第一种 ...
mysql 触发器语法
mysql 的sql语句如下：
mysql> delimiter //
-> create trigger sitedata_ins2
-> before insert on user
-> for each row
-> Begin
-> If not exists(select 1 from user_data where d_id=new.id) then
-> insert into user_data(d_id,d_name) values(new.id,new.name);
-> END IF;
-> end;//
-> delimiter ;
或者简单一点：
mysql> delimiter //
-> create trigger sitedata_ins2
-> before insert on user
-> for each row
-> Begin
-> insert into user_data(d_id,d_name) values(new.id,new.name);
-> end;//
-> delimiter ;
二种方法都可以，建议你用第一种2010-09-27
