mysql拷贝另一个表且加入拷贝时间

insert into radartrackrecord_h (flightJson,CreateTime,UpdateTime) (select flightJson,CreateTime,NOW()  from radartrackrecord_c where CreateTime <= '2020-11-16 13:00:00')

原文地址:https://www.cnblogs.com/0280-hnn/p/13984592.html