Inspiration For Creative Minds
Home » Labs » Delete records within a specific Range from MySQL table  

Filed under Labs

If you want to delete a range of records from MySQL table then you can use following query. Below example will delete records within the ID 1000 and 5000.

delete from table_name where ID between 1000 and 5000

or you can use below query for the same.

	delete from table_name where id >= 1000 and id <= 5000
It's only fair to share...Share on Google+Tweet about this on TwitterShare on Facebook

Posts you may like: