delete from where +date_sub(date(now()+interval 12 month);例mysql+ select + from name where csny+date_sub(date(now()+interval 1 month);+-+-+-+-++ id + xm + xb + csny ++-+-+-+-++ 16 + Apri26 + gl + 2012-04-26 + +-+-+-+-+1 row in set (0.00 sec)mysql+ delete from name where csny+date_sub(date(now()+interval 1 month);Query OK+ 1 row affected (0.14 sec)mysql+ select + from name where csny+date_sub(date(now()+interval 1 month);Empty set (0.00 sec) mysql+表空间(条件)===2
说明:
select*fromtestwherecsny=12;
这里的引用都是空格,仅供参考,后面会分享更多devops和DBA方面的内容,感兴趣的朋友可以关注下!