delimiter// createtrigger trg_order_inser afterinserton orders
for each rowbegininsertinto order_log(o_date,order_num)values(now(),new.order.num);end;//
使用触发器
createtable order_log(id intauto_incrementprimarykey,o_date datetime,order_num int);droptrigger trg_order_inser;createtrigger trg_order_inser afterinserton orders
for each rowbegininsertinto order_log(o_date,order_num,dml_type)values(now(),new.order.num,'insert');end;insertinto orders (order_date,cust_id)values('2021-1-1',10005);
删除触发器
createtrigger trg_order_delete afterdeleteon orders
for each rowbegininsertinto order_log(o_date,order_num,dml_type)values(now(),old.order.num,'delete');end;deletefrom orders where order_num =2010;
更新触发器
createtrigger trg_order_update afterupdateon orders
for each rowbegininsertinto order_log(o_date,order_num,dml_type)values(now(),old.order.num,'update');end;// update 操作delimiter//createtrigger trg_products_update before updateon product
for each rowbeginif new.prod_price>old.prod_price *1.2thenset new.prod_price = old.prod_price *1.2;endif;end;//