mysql 查询最大日期

SELECT MAX(order_date) AS max_date FROM orders;

SELECT c.customer_id, MAX(o.order_date) AS max_order_date
FROM orders o
JOIN customers c ON o.customer_id = c.customer_id
GROUP BY c.customer_id;

SELECT MAX(order_date) AS max_date FROM orders WHERE order_date IS NOT NULL;

CREATE INDEX idx_order_date ON orders(order_date);

ALTER TABLE orders PARTITION BY RANGE (TO_DAYS(order_date)) (
    PARTITION p0 VALUES LESS THAN (TO_DAYS('2020-01-01')),
    PARTITION p1 VALUES LESS THAN (TO_DAYS('2021-01-01')),
    PARTITION p2 VALUES LESS THAN (TO_DAYS('2022-01-01')),
    PARTITION p3 VALUES LESS THAN MAXVALUE
);