update b b set b.value=(select max(a.value) from a a where b.key=a.key) where exists(select 1 from a c where b.key=c.key)
update a a,(select a.`key`,b.`value` from a inner join b on a.`key`=b.`key`) b set a.`value` = b.`value` where a.`key` = b.`key`
如对本文有疑问, 点击进行留言回复!!
服务器Centos部署MySql并连接Navicat过程详解
网友评论