Ashley Brown Ashley Brown - 2 years ago 97
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 Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download