Delete rows older than x days or x months in MySQL

20th Jun 2008

Delete rows older than x days or x months in MySQL

DELETE FROM `tablename` WHERE `created` < DATE_SUB(NOW(), INTERVAL 5 DAY);

DELETE FROM `tablename` WHERE `created` < DATE_SUB(NOW(), INTERVAL 1 MONTH);

This entry was posted on Friday, June 20th, 2008 at 10:25 am and is filed under Snippets, PHP. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

CSS Design Google News PHP Random Search Snippets Sponsors Troubleshooting Tutorials WordPress WWW xHTML

Web design Sydney - Get your business online within a week

About: The blog esn studio is where I keep myself up to date with the latest technologies in the industry and share my ideas and thoughts with like-minded...
Adsense Tips and Tricks: With personal and commercial blogs, community websites, and social pages becoming the hot topic of the Internet in the last few years, many people h...
Advertise With Us: esn studio is a blog about Web Development, Web Design, Web Applications, Web 2.0, AJAX, Search Engine Optimisation, Latest Technologies and more. ...
Archive: Grab yourself a cup of coffee or tea, sit back and browse through an archive of all the blog posts on esn studio....
Choosing a Content Management System: The most commonly asked question when it comes to Content Management System is whether to build or buy (pre-built). While there are many factors to b...
Customised Wordpress Themes: This service is currently not available. ...
Favourite Poems: If by Rudyard Kipling If you can keep your head when all about you Are losing theirs and blaming it on you, If you can trust yourself when al...
Favourites: My VisualDNA Read my VisualDNA™ Get your own VisualDNA Get your VisualDNA from imagini! ...
How to Start a Blog?: What's a blog? According to Wikipedia, a blog is a user-generated website where entries are made in journal style and displayed in a reverse chrono...
Links: Free Anonymous Proxy Increases your privacy and security on the Internet by using our free, fast and easy to use web proxy. High-Tech Outsourcin...
Making a Passive Income Online: Passive income, in my opinion, means an income which does not require a lot of regular maintenance work or continuing effort. I have been thinking ab...
Online Distribution Channels: One of the importances of any website or business is to bring your products or services to the right people and to reach the target audience. There a...
Recent Projects: Followings are some of the recent projects I have done in 2006 -- 2007. Check out my latest business venture Web design Sydney to get your business ...
Search: Looking for something on esn studio? Use this search tool powered by Google Custom Search to find what you are looking for just in a matter of second...
Seven Tips to Increasing Your Website’s Traffic Using SEO: SEO is the buzz word – many people have mentioned it and many have heard of it too, but very few people know how to implement it properly. SEO, sta...
Subscribe: Subscribe to esn studio via RSS 2.0 feeds: Entries feed Comments feed Subscribe using your favourite web-based or desktop feed reader: ...
Useful Linux Commands: Find files older than 60 days find * -mtime +60 Delete files in backup folder which are older than 60 days rm -f `find /backup/ -mtime +60` Se...
Web Design Tips: Nowadays, having a website for your business is like having a phone number. Almost every business has their own website, with their own domain name. W...
Web Development Books: ...
Web Standards: Web Standards is defined as a set of rules or specifications that should be followed when developing a website. The main objectives of web stan...
WordPress Themes: All WordPress themes are designed and coded by esn studio, and licensed under GPL license. For more information about the themes, please contact me. ...

Categories
- - CSS (15)
  - Design (28)
  - Google (22)
  - News (35)
  - PHP (29)
  - Random (35)
  - Search (20)
  - Snippets (17)
  - Sponsors (7)
  - Troubleshooting (8)
  - Tutorials (12)
  - WordPress (27)
  - WWW (81)
  - xHTML (10)
Archives
Links
Sponsors

esn studio

Web Development, Web Design, Web Applications, Web 2.0, AJAX, WordPress Themes, Search Engine Optimisation, Latest Technologies and more..

Delete rows older than x days or x months in MySQL

Leave a Reply

Categories

Archives

Links

Sponsors