m0_52433668的博客

Mysql创建触发器-删除一条数据的同时将这条数据添加进备份表CREATE TRIGGER removed_products_trigger AFTER DELETE ON product_info FOR EACH ROW BEGIN INSERT INTO removed_products(code,name,tid,brand,pic,num,price,intro) values(OLD.code,OLD.name,OLD.tid,OLD.brand,OLD.pic,OLD.n