Mysql多表联合更新、删除
标签：user delete bsp upd color nbsp mysql inner mes
Mysql多表联合更新、删除
DELETE ucr FROM snyts_user_class_rel ucr
INNER JOIN snyts_order o
ON ucr.user_id = o.user_id AND ucr.class_id = o.class_id
INNER JOIN snyts_refund_order r
ON o.order_id = r.order_id
WHERE r.refund_order_id = :refundOrderId