首页 > > 网络编程 > Mysql >

MySql 批量更新语法

2018-06-18 00:05:54来源：未知阅读 ()

mysql数据库在批量更新某表的字段时，语法如下：

UPDATE A AS a
INNER JOIN (
SELECT
*
FROM
A
WHERE
....
) AS b ON a.order_id = b.order_id
SET a.pay_status = 2 ,a.abnormal = 4;

举例：

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;

标签：

版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com
特别注意：本站所有转载文章言论不代表本站观点，本站所提供的摄影照片，插画，设计作品，如需使用，请与原作者联系，版权归原作者所有