CODEWITHSUNDEEP
mysqlsql
ProEvilz
ProEvilz

Reputation: 5445

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

Is there an 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;

Upvotes: 33

Views: 86998

Answers (1)

frlan
frlan

Reputation: 7270

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.

Upvotes: 70

Related Questions