本文介绍了一种通过SQL查询来更新数据库中地点注册信息的方法。主要针对地点代码对应的外部名称进行更新操作，确保数据库中地点信息的准确性。
update spot s set s.name = (select ss.outername from spotregister ss where s.spotcode = ss.spotcode and ss.outername is not null),
s.outername = (select ss.outername from spotregister ss where s.spotcode = ss.spotcode and ss.outername is not null)
where s.spotcode in (select ss.spotcode from spotregister ss where s.spotcode = ss.spotcode and ss.outername is not null)
实现2个表的联合update
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
