如果您知道如何从表中选择873行，则应该做这样的事情。以下是删除所有选定行的方法，在本示例中，所有行除id介于3和5之间的行...

if you know how to select your 873 rows from your table you should do something do like this. Here is how to delete all rows except selected, in this example all rows except those where id is between 3 and 5...

 DELETE FROM table1
 WHERE id NOT IN (SELECT id FROM table1 WHERE id BETWEEN 3 AND 5);

这里是SQL Fiddle，它用来查看 http://sqlfiddle.com/#!7/3d657/1

Here is SQL Fiddle for that to see how that look like http://sqlfiddle.com/#!7/3d657/1