SELECT a.voyageNum,CONCAT(a.startDate,'~',a.endDate) AS 日期 FROM tchw_voyageoilcost a ,tchw_voyageoilcostinfo b WHERE a.isDeleted=0 AND a.id=b.voyageOilCostId AND a.shipId=3 AN...
--1、创建一个备份表:
select * into Users_Bak from Users
--2、依据某个表进行更新:
update Users_Bak
set Users_Bak.Mobile = BasicInfo.Mobile,
Users_Bak.Email = BasicInfo.Email
from Basic...