Delete records within a specific Range from MySQL table

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.

<?php
delete from table_name where ID between 1000 and 5000
?>

or you can use below query for the same.

<?php
	delete from table_name where id >= 1000 and id <= 5000
?>
Tags: ,

Related posts:

HTML5 page structure

HTML5 offers more powerful structure comparing to older versions of Html. There are many new …


Partner with Us

We are providing an exclusive partnership offer to individuals and companies who are interested in setting up their own web design & development company. For more information about how to partner with us, please contact us