mysql删除每天数据

delete from A WHERE HOUR(UPDATED_AT)=3 or HOUR(UPDATED_AT)=5;--删除每天3点和5点数据

 

delete from A WHERE HOUR(UPDATED_AT)=3 between and HOUR(UPDATED_AT):--删除3点到5点直接数据

 

posted @ 2022-06-02 15:46  小正哥  阅读(227)  评论(0编辑  收藏  举报