UPDATE语句格式类似于INSERT语句(UPDATE statement format analogous to INSERT statement)
我知道UPDATE语句具有以下格式:
UPDATE table_name SET column1=value1,column2=value2,... WHERE some_column=some_value;我想知道是否存在类似于INSERT语句的格式,如下所示:
UPDATE table_name SET (column1,column2,column3,...) VALUES (value1,value2,value3,...) WHERE some_column=some_value;这是一个有效的查询?
我正在使用MySQL。
I know that the UPDATE statement has the following format:
UPDATE table_name SET column1=value1,column2=value2,... WHERE some_column=some_value;I was wondering whether there exists a format analogous to INSERT statement, something like this:
UPDATE table_name SET (column1,column2,column3,...) VALUES (value1,value2,value3,...) WHERE some_column=some_value;Is this a valid query?
I'm using MySQL.
最满意答案
简短的回答 - 没有。
update语法的所有变体都有一个colulmn1=..., column2=...等形式的set子句。有关支持的语法变体的完整列表,您可以查看文档 。
The short answer - no.
All the variants of the update syntax have a set clause of the form colulmn1=..., column2=... etc. For a complete list of the supported syntax variants, you can check out the documentation.
更多推荐
发布评论