MySQL删除id大于给定数字的所有行 [英] MySQL delete all rows where id is greater than the given number

问题描述

是否可以运行一个Sql查询，使我能够删除ID大于10的所有行?

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?

类似这样的东西.

我有两列，ID和Name

I have two columns, ID and Name

DELETE FROM table_name WHERE ID=>10;

推荐答案

您的查询几乎是完美的;)

Your query was nearly perfect ;)

只需尝试

DELETE FROM table_name WHERE ID>9;

您也可以使用

DELETE FROM table_name WHERE ID>=10;

您已经提到过.

这篇关于MySQL删除id大于给定数字的所有行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！