mysql下updete多表联合更新

来源:互联网 发布:知乎ios7 编辑:程序博客网 时间:2024/05/30 23:16

UPDATE `tony_passport_item` a LEFT JOIN `tony_shop` b ON b.sid = a.pi_sid

SET a.pi_v_fueltamk =b.s_v_fueltamk

WHERE a.piid = 1

0 0