1. 查询10天内的数据: SELECT * FROM tableInfo where TO_DAYS(NOW())-TO_DAYS(CreateTime)<10; 2. 查询大于10天的数据: SELECT * FROM tableInfo where TO_DAYS(NOW())-TO_DAYS(CreateTime)<10; 3. 删除10天以外的数据: DELETE FROM tableInfo where TO_DAYS(NOW())-TO_DAYS(CreateTime)>10;
sql查询/删除表N天内数据
最新推荐文章于 2023-04-07 10:48:02 发布