MYSQL更新A表的数据到B表

UPDATE zh_users AS a ,zh_withdrawals AS b  SET a.user_money =a.user_money+b.withdra_money WHERE a.user_id=b.user_id AND b.id  IN (51169,

51180,

52177,

51196

)

 

 

https://deepinout.com/mysql/mysql-questions/288_hk_1707400860.html#google_vignette