Mysql多表联合更新、删除
时间:2021-07-01 10:21:17
帮助过:13人阅读
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
Mysql多表联合更新、删除
标签:user delete bsp upd color nbsp mysql inner mes