澜色海湾的博客Mysql创建触发器-删除一条数据的同时将这条数据添加进备份表 CREATE TRIGGER removed_products_trigger AFTER DELETE ON product_info FOR EACH ROW BEGIN INSERT INTO removed_products(code,name,tid,brand,pic...
一路走来516的博客需求:有个表 table1,当向 table1 insert 数据 xx,xx,5555,xx时,触发建立一个新表 t5555不能做到在TRIGGER中建立表,会提示Explicit or implicit commit is not allowed in stored function or trigger....