我的表中的行超过60000。如何一次将行从40000删除到50000?
您可以使用以下between功能:
between
delete from exampleTable where id between 40000 and 50000
要么:
delete from exampleTable where id >= 40000 and id <= 50000
很简单?