Question

How to delete multiple rows in SQL where id = (x to y) (5 answers)

Closed 6 years ago.

对某些有经验的人来说,这可能是一个非常简单的问题,但我只想知道最安全的方法,在一张属于特定范围的文件桌上删除100份记录。

例如,我需要删除在79和64之间有身份证的行文;296:

我担心的是,如果我说删除了所有有身份证(>79和“lt;296)的人,那么,这实际上会抹去整个表格。

Answer 1

如果你使用Sql服务器

delete from Table where id between 79 and 296

注:between statement is Inclusive, so rows 79 and 296 还将删除<>。

<<><><>After You edit : 你现在澄清说,你想要:

ID (>79 < 296)

因此:

delete from table where id > 79 and id < 296

Answer 2

回答是:

delete from tab
where id > 79 and id < 296

这与:

delete from tab
where id between 80 and 295

<代码>id为立体。

All answered:

delete from tab
where id between 79 and 296

这与:

delete from tab
where id => 79 and id <= 296

区分。

Answer 3

DELETE FROM table_name 
WHERE id BETWEEN 79 AND 296;

Answer 4

页: 1

并测试选择

选定的记录将与删除的记录相同。

如果你不肯定的话,你也可以在开始/退席上放弃发言,那么如果所有发言都是好的,你就可以检验发言。

for example

SELECT * FROM table WHERE id BETWEEN 79 AND 296

will show all the records matching the where if they are the wants you really want to delete then use

DELETE FROM table WHERE id BETWEEN 79 AND 296

你们也可以创造出一个触发点,可以赶走,将其带入历史桌。

so if you delete something by mistake you can always get it back

(维持历史记录,时间不超过6个月,或不论业务规则如何)

Answer 5

如果你将数据库表写成服务器中的下列数值,那么,除非表中的所有数值实际上在这些数值之间:

DELETE FROM [dbo].[TableName] WHERE [TableName].[IdField] BETWEEN 79 AND 296

Answer 6

My worry is if I say delete evertything with an ID (>79 AND < 296) then it may literally wipe the whole table...

之所以成功,是因为你将有一个条款。实际情况是,如果你有像<编码>代谢*”这样的声明,如果在表1中,在70到1296<<>>/code>之间,则单单单单项是扫描表格,并寻找这些记录,然后删除。

Answer 7

你们可以采用这种方式,因为id在任何情况下都不可能是连续的。

SELECT * 
FROM  `ht_news` 
LIMIT 0 , 30