//查詢舊表一天的數據
SELECT COUNT(*) FROM orders
WHERE created_time >= 1561824000 and created_time <1561910400;

//查詢結轉表這一天是否有數據
SELECT COUNT(*) FROM zb_orders
WHERE created_time >= 1561824000 and created_time <1561910400;

//查詢結轉表是否有舊表的數據
SELECT COUNT(*) FROM orders where order_id not in (SELECT order_id FROM zb_orders
WHERE created_time >= 1561824000 and created_time < 1561910400)
AND created_time >= 1561824000 and created_time < 1561910400;

//如果有舊表的數據那么只插入舊表不存在的數據
INSERT INTO zb_orders
SELECT * from orders where id not in (
SELECT id from zb_orders where created_time >= 1561824000 and created_time < 1561910400
) AND created_time >= 1561824000 and created_time < 1561910400;

//如果不存在舊表數據那么執行這個
INSERT INTO zb_orders
SELECT * FROM orders
WHERE created_time >= 1561824000 and created_time <1561910400;

//最后刪除舊表的數據
DELETE FROM orders WHERE created_time >= 1561824000 and created_time <1561910400;

總結

以上是生活随笔為你收集整理的数据库 结转数据 sql结转的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。