你可以用update: update b inner join a on a_co1=b_co1 and ifnull(b.b_co2,'')='' set b.b_co2=a.a_co2; 参考自: mysql多表更新(跨表更新) http://www.data.5helpyou.com/article252.html |
|申请友链|小黑屋|Archiver|手机版|MySQL社区
( 京ICP备07012489号 )
联系人:周生; 联系电话:13911732319
GMT+8, 2024-5-5 06:10 , Processed in 0.067097 second(s), 30 queries , Gzip On.
Powered by Discuz! X3.2
© 2001-2013 Comsenz Inc.