當從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`,`ch ...
當從B表數據更新到A表時：
update A inner join B on A.aid=B.aid
set A.user_name=B.username,A.phone=B.tel
where A.aid=A.aid
當從B表數據插入到A表時：
insert A(`aid`,`typeid`,`channel) select `aid`,`typeid`,`channel` from B where aid>5960
