Mass remove rows from a table

is there a query i can use to remove a large number of rows from a database i have? using php myadmin.

 

Which rows? You'll need a condition to select which rows you wish to drop.

 

this table has 90,851 rows.

i want to remove all rows from row number 88633 to the end.

 

i guess i'm all set. here is the query:
DELETE FROM tablename WHERE id >1;

 

That will wipe the lot.

If you have an auto_increment'd field called id and you want to remove all the lines where id is equal to 88633 to the end of the table, then:

DELETE FROM tableName WHERE id > 88632;

Code (markup):

will do it.

Sounds like you might want to ensure you have the DB backed up before doing it.

 

no it won't. it will remove exactly what i want removed and it did.

 

delete from tablename

will just work fine

Thanks

Lavee