mysql按年月统计

SELECT 
    YEAR(order_date) AS year,
    MONTH(order_date) AS month,
    SUM(amount) AS total_amount
FROM 
    orders
GROUP BY 
    YEAR(order_date), MONTH(order_date)
ORDER BY 
    year, month;

SELECT 
    YEAR(order_date) AS year,
    SUM(amount) AS total_amount
FROM 
    orders
GROUP BY 
    YEAR(order_date)
ORDER BY 
    year;

UPDATE orders
SET order_date = STR_TO_DATE(order_date, '%Y-%m-%d')
WHERE order_date IS NOT NULL;

CREATE INDEX idx_order_date ON orders(order_date);

SELECT 
    YEAR(order_date) AS year,
    MONTH(order_date) AS month,
    SUM(amount) AS total_amount
FROM 
    orders
GROUP BY 
    YEAR(order_date), MONTH(order_date)
ORDER BY 
    year, month
LIMIT 10 OFFSET 0;