MYSQL–例子说明

1.创建订单表

2.创建订单详情表

3,在创建订单表时，创建订单表的一样的订单状态
4.在更新订单表时，更新订单表的一样的订单状态
5.在删除订单表时，删除订单表的一样的订单状态
代码如下：
1.创建订单：

delimiter $$
create trigger crea_order_satus
AFTER INSERT ON t_order
FOR EACH ROW
begin
insert into order_details(order_status,order_id) values(new.ostatus,new.order_oid);
end
$$
delimiter ;

2.更新订单

drop trigger if exists up_order_satus;
delimiter $$
create trigger up_order_satus
after UPDATE ON t_order
FOR EACH ROW
begin
update order_details set order_details.order_status=new.ostatus where order_details.order_id=old.order_oid;
end
$$
delimiter ;

3.删除订单

drop trigger if exists del_order_satus;
delimiter $$
create trigger del_order_satus
after DELETE ON t_order
FOR EACH ROW
begin
DELETE from order_details where order_details.order_id=old.order_oid;
end
$$
delimiter ;