MySql 批量更新语法

UPDATE Yamibuy_Master.xysc_order_info AS oi
INNER JOIN (
SELECT
order_id,order_sn,pay_status,abnormal
FROM
Yamibuy_Master.xysc_order_info
WHERE
abnormal = !4
AND order_status = 1
AND shipping_status = 0
AND pay_status = 0
AND warehouse_number = 002
) AS A ON oi.order_id = A.order_id
SET oi.pay_status = 2 , oi.abnormal = 4;

MySql 批量更新语法

标签：mysq   back   ...   更新   order   master   mysql   举例   nbsp