mysql不支持update set from where这种写法,改用update inner join on set
update set from where时报错
update a.pay_info set a.need_pay=b.pay from brick.pay_info a ,(select debt+pay_way as pay , pay_id from brick.pay_map) b where a.pay_id = b.pay_id ;
报错信息15:55:21 Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘from brick.pay_info a ,(select debt+pay_way as pay , pay_id from brick.pay_map’ at line 1 0.000 sec from处显示显示from is not valid at this
改用update inner join on set
update (select debt+pay_way as pay , pay_id from brick.pay_map) b inner join brick.pay_info a on a.pay_id = b.pay_id set a.need_pay=b.pay ;