最好的方法是使用IN
语句:
DELETE from tablename WHERE id IN (1,2,3,...,254);
BETWEEN
如果您有连续的ID,也可以使用:
DELETE from tablename WHERE id BETWEEN 1 AND 254;
您当然可以使用其他WHERE子句来限制某些ID:
DELETE from tablename WHERE id BETWEEN 1 AND 254 AND id<>10;
在MySQL中使用ID从表中删除许多行
最好的方法是使用IN
语句:
DELETE from tablename WHERE id IN (1,2,3,...,254);
BETWEEN
如果您有连续的ID,也可以使用:
DELETE from tablename WHERE id BETWEEN 1 AND 254;
您当然可以使用其他WHERE子句来限制某些ID:
DELETE from tablename WHERE id BETWEEN 1 AND 254 AND id<>10;