mysql - 从mysql表中删除特定日期记录

Question

我想从MYSQL表中删除特定日期的记录

在 TIMESTAMP 中插入日期

我试过这个查询但没有成功:

DELETE FROM `tracking` WHERE `track_time` = '2015-03-07'

表中的记录在那个时间戳中出现

DELETE FROM `tracking` WHERE `track_time` = '2015-03-07'

2014-05-28 00:00:02

请告诉我

Answer 1

试试这个:

DELETE FROM tracking WHERE date(track_time) = '2015-03-07'

或

DELETE FROM tracking 
WHERE track_time > '2015-03-07 00:00:02' and track_time < '2015-03-08 00:00:02'