通过UPDATE查询 [英] Pass Through UPDATE Query

问题描述

执行以下更新时：

When performing the following update:

展开 | 选择 | Wrap | 行号

推荐答案

让我来处理一次点一个。

Let me deal with points one at a time.

1. 我已经删除了你错误发布的其他帖子，所以不用担心。
2. 你显然已经努力清楚地展示代码。将来，只需使用提供的[CODE]标签（单击哈希（＃）按钮）。
3. 您的第一个SQL字符串包含 TWO WHERE关键字。这会混淆SQL引擎，并可能解释你的问题。

1. I''ve deleted your other thread where you posted in error so needn''t worry about that.
2. You''ve obviously made efforts to show the code clearly. In future, simply use the [ CODE ] tags provided (click on the hash (#) button).
3. Your first SQL string has TWO WHERE keywords. This will confuse the SQL engine and may explain your problems.

尝试修复它，让我们知道你是怎么做的。

try fixing that and let us know how you get on.

谢谢我还是一个新手，你可以看到！想知道大家是怎么做到的。

请忽略第二个WHERE，这显然是我的错误，因为它在我的代码中不存在。

Thanks i''m still a newbie as you can see! Was wondering how everyone did that.
Please ignore the second WHERE, obviously a pasting error on my part as it does not exist in my code.

Scratch the关于WHERE子句的评论（＃3）。我错过了括号。

但是，似乎（从帮助中）更新表中不支持 AS别名谓词。

Scratch the comment (#3) about the WHERE clauses. I missed the parentheses.
However, it seems (from the help) that the AS Alias predicates are not supported in the Update table.

这篇关于通过UPDATE查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！