需求:求2024-05月的value的和
方法一 :DATE_FORMAT() 函数
SELECT
IFNULL(SUM(value), 0) AS sumVal
FROM
table
WHERE
DATE_FORMAT(data_day, '%Y-%m') = '2024-05';
方法二:截取
SELECT
IFNULL(SUM(value), 0) AS sumVal
FROM
table
WHERE left(data_day,7)= '2024-05';