根据一张表修改另一张表某字段的sql

注意update操作的时候不萌直接更新临时表，没法对磁盘进行操作

SELECT
ORDER_ID,
MOBILE
FROM
`t_order`
WHERE

ORDER_ID ="P2201140413110066"

update t_order as t LEFT JOIN t_order_buyer as b on t.ORDER_ID = b.ORDER_ID
set t.MOBILE = b.BUYER_PHONE
where b.CREATE_TIME BETWEEN "2022-01-14 00:00:00"
AND "2022-01-14 23:59:59"


SELECT
b.ORDER_ID,
b.BUYER_PHONE,
t.MOBILE
FROM
`t_order_buyer` as b LEFT JOIN t_order as t on t.ORDER_ID = b.ORDER_ID
WHERE
b.CREATE_TIME BETWEEN "2022-01-14 00:00:00"
AND "2022-01-14 23:59:59"
and t.MOBILE is null