--查询记录 select * from t_scpdgy where 日期<'2019-12-12' order by 日期 desc --删除记录裁断工艺记录 delete from t_scpdgy where 日期<'2019-12-12' --删除针车记录 select * from t_scpd3 where 日期<'2019-12-12' order by 日期 desc --删除针车记录 delete from t_scpd3 where 日期<'2019-12-12' --删除成型记录 select * from t_scpd2 where 日期<'2019-12-1' order by 日期 desc delete from T_scpd2 where 日期<'2019-12-1'