Delete rows older than x days or x months in MySQL

20 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);

Love what you've just read? Subscribe to our newsletter to receive tips, resources and special offers related to web development & design.

Other similar posts that you might be interested in:

Comments are closed.

Hello! Welcome to Web development blog! My name is Ei Sabai and on this blog, I write about web development, mobile app development, latest web technologies and the likes. Read more about me or have a look at some of the tips & resources I've written.

Search

Tips & Resources

WordPress Web Hosting: Recommended web hosting providers for WordPress 3.0
iPhone Native App Development: Important steps into iPhone app development for beginners
iPhone Web App Development: Tips for iPhone web app development
Coupons for Web Developers: Get discounts on web hosting, domain names, templates, etc
10 Useful jQuery Snippets: Easy-to-use jQuery snippets for any website
HTML Email Newsletter: Step-by-step tutorial on how to code an HTML email newsletter