我创建了2个表,一个订单表order1(oid,pid)和一个订单记录表logsheet(lid,oid,time,state(订单成交状态))
想要在order1上创建触发器:当删除order1一条记录时,在logsheet中相应的oid那个记录状态改为“失败”
CREATE TRIGGER aa
AFTER DELETE on order1
FOR EACH ROW
BEGIN
UPDATE orderlogsheet
SET orderlogsheet.state='失败'
WHERE orderlogsheet.oid=order1.oid;
END