我可以将这些更新查询合并到一个查询中吗 [英] 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屋！