Ashley Brown Ashley Brown - 5 months ago 16
SQL Question

MySQL delete all rows where id is greater than the given Number

Is there a Sql query I can run that will enable me to delete all rows where the ID is greater than let's say 10?

Something like this.

I have two columns, ID and Name

DELETE FROM table_name WHERE ID=>10;

Answer

Your query was nearly perfect ;)

Just try

DELETE FROM table_name WHERE ID>9;

You could also use

DELETE FROM table_name WHERE ID>=10;

As you already mention.

Comments