我尝试了自己,这是可行的:
SELECT count(id) FROM `tasks ` WHERE due_date= CURRENT_DATE
SELECT count(id) FROM `tasks ` WHERE due_date = CURDATE()
计算到期日期与今天的日期匹配的数据库中的所有记录
我尝试了自己,这是可行的:
SELECT count(id) FROM `tasks ` WHERE due_date= CURRENT_DATE
SELECT count(id) FROM `tasks ` WHERE due_date = CURDATE()