实用日记

# 复制一张大表的部分数据到新表
# 创建新表(与旧表保持数据结构一直)
CREATE TABLE `order_clone` LIKE `order`;
# 查询并写入新表数据(强制走索引,否则会锁表)
INSERT INTO `order_clone`
SELECT * FROM `order` FORCE INDEX ( `created_at` ) 
WHERE `from` = '出行' 
    AND `status` = '-1' 
    AND `created_at` >= '2021-07-16 16:30:29' 
    AND `created_at` <= '2021-10-08 00:00:00';