我可以将这些更新查询合并到一个查询中吗 [英] can i combine these update queries into one query
本文介绍了我可以将这些更新查询合并到一个查询中吗的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
在具有名为NewTable3的表的MS-Access数据库中
In an MS-Access database with Table called NewTable3
我可以将这3个sql查询合并为一个查询
can i combine these 3 sql queries into one query
UPDATE NewTable3 SET SAO = '0' WHERE SAO LIKE '-';
UPDATE NewTable3 SET SAO = '0' WHERE SAO LIKE 'NULL';
UPDATE NewTable3 SET SAO = '0' WHERE SAO LIKE 'NA';
推荐答案
使用OR
怎么办?
UPDATE NewTable3
SET SAO = '0'
WHERE (WAP LIKE '-') OR (WAP IS NULL) OR (WAP LIKE 'NA');
您可以了解有关在SQL查询AND和OR
的更多信息. >这里.
You can learn more about using AND
and OR
in SQL queries here.
原始问题包括条件WAP LIKE 'NULL'
.正确的符号是WAP IS NULL
而不是WAP LIKE 'NULL'
; Null不是文本NULL
,而是
The original question included the condition WAP LIKE 'NULL'
. The correct notation is WAP IS NULL
" and not WAP LIKE 'NULL'
; Null isn't the text NULL
but a special, none-textual value.
这篇关于我可以将这些更新查询合并到一个查询中吗的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文