sql-delete - 如何缩短数据库表的 DELETE 语句？

Question

你好，有没有办法把它放在一个声明中？

DELETE e_worklist where wbs_element  = '00000000000000000054TTO'.
DELETE e_worklist where wbs_element  = '00000000000000000056TTO'.
DELETE e_worklist where wbs_element  = '00000000000000000055TTO'.
DELETE e_worklist where wbs_element  = '00000000000000000261TTO'.
DELETE e_worklist where wbs_element  = '00000000000000000263TTO'.
DELETE e_worklist where wbs_element  = '00000000000000000262TTO'.

Answer 1

上面建议的带有 IN 的答案仅对数据库表有效:

DELETE FROM e_worklist where wbs_element IN ( '00000000000000000054TTO', '00000000000000000056TTO', '00000000000000000055TTO' ).

在您的示例中，您放置了内部表语句，并且对于它们建议的 IN 语法对文字无效。有效 only with selection tables/ranges , 这也需要是 populated properly .所以你不能只是将文字包装到 IN 子句中，你需要像这样做:

ws_wbs-sign   = 'I'. 
ws_wbs-option = 'EQ'. 
ws_wbs-low    = '00000000000000000054TTO'. 
APPEND ws_wbs TO rt_wbs. 

DELETE e_worklist WHERE wbs_element IN rt_wbs.

这确实很麻烦，而且不会给您带来简洁。

但是，由于你的模式是单调的，你可以发挥你的想象力并使用正则表达式，例如:

DELETE e_worklist WHERE wbs_element CP '00000000000000000*TTO'.