mysql 取前一天的数据

SELECT *
FROM orders
WHERE created_at >= DATE_SUB(CURDATE(), INTERVAL 1 DAY)
  AND created_at < CURDATE();

SELECT *
FROM orders
WHERE CONVERT_TZ(created_at, @@session.time_zone, '+00:00') >= DATE_SUB(CURDATE(), INTERVAL 1 DAY)
  AND CONVERT_TZ(created_at, @@session.time_zone, '+00:00') < CURDATE();

-- 创建索引
CREATE INDEX idx_created_at ON orders(created_at);

-- 分区表示例
ALTER TABLE orders
PARTITION BY RANGE (TO_DAYS(created_at)) (
    PARTITION p0 VALUES LESS THAN (TO_DAYS('2022-01-01')),
    PARTITION p1 VALUES LESS THAN (TO_DAYS('2023-01-01')),
    PARTITION p2 VALUES LESS THAN MAXVALUE
);