delete from t_agent_file where date(str_to_date(`t_agent_file`.`publish_date`,'%Y-%m-%d')) between '2015-06-01' and '2015-06-18'
mysql varchar类型转换日期类型,比较大小
最新推荐文章于 2022-07-26 22:59:26 发布
delete from t_agent_file where date(str_to_date(`t_agent_file`.`publish_date`,'%Y-%m-%d')) between '2015-06-01' and '2015-06-18'