delete from 表名 where date(时间的字段名) < date(now())
SELECT
*
FROM
student
WHERE
created_date BETWEEN '2018-09-09'
AND DATE_ADD('2018-09-09' ,INTERVAL 1 DAY)
delete from 表名 where date(时间的字段名) < date(now())
SELECT
*
FROM
student
WHERE
created_date BETWEEN '2018-09-09'
AND DATE_ADD('2018-09-09' ,INTERVAL 1 DAY)