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

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

posted @ 2020-11-16 13:10  蓁蓁  阅读(145)  评论(0)  编辑  收藏  举报