当前位置:Gxlcms > 数据库问题 > Mysql多表联合更新、删除

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   

人气教程排行