当从B表数据更新到A表时:
update A inner join B on A.aid=B.aid set A.user_name=B.username,A.phone=B.telwhere A.aid=A.aid
当从B表数据插入到A表时:
insert A(`aid`,`typeid`,`channel) select `aid`,`typeid`,`channel` from B where aid>5960
Powered by: 博客园 Copyright © 2024 龙翔天下 Powered by .NET 8.0 on Kubernetes