delimiter///createtrigger update_name
afterupdateon author for each rowbeginINSERTINTO name_log (old_name , new_name)values(OLD.name , NEW.name);end;///
向t1表插入1条时同时也向t2插入1条数据
delimiter///createtrigger tg1 before inserton t1 for each row;...delete......update...begininsertinto t1(name) vaules(new.name);
删除表t1后t2表中的记录跟着变
deletefrom t1 where name = old.name;
更改表t1后t2表中的记录跟着变
update t2 set name=new.name where name = old.name;end;///
createtable tab_int_some(
id int,
age tinyint);delimiter///createtrigger trigger_copy1 before inserton tab_int for each rowbeginset@v1= new.f1;#获取新行字段f1的值set@v2= new.f2;#获取新行字段f2的值insertinto tab_int_some(id, age)values(@v1,@v2);end;/////testinsertinto tab_int values(21,22,23);