如何在MySQL的当月第一天和当前日期之间进行选择？

SELECT * FROM table_name
WHERE date_column BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 1 DAY);

INSERT INTO new_table_name (column1, column2, column3)
SELECT column1, column2, column3
FROM table_name
WHERE date_column BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 1 DAY);

SELECT * FROM table_name
WHERE date_column BETWEEN STR_TO_DATE(CONCAT(CURDATE(), ' 00:00:00'), '%Y-%m-%d %H:%i:%s') AND DATE_ADD(STR_TO_DATE(CONCAT(CURDATE(), ' 00:00:00'), '%Y-%m-%d %H:%i:%s'), INTERVAL 1 DAY);