159.View the Exhibit and examine the structure of the CUSTOMERS table.

最新推荐文章于 2016-08-07 16:12:32 发布

今年我18

最新推荐文章于 2016-08-07 16:12:32 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

分类专栏： 1z0-051 文章标签： 1z0-051

本文链接：https://blog.youkuaiyun.com/dwj19830118/article/details/50899496

1z0-051 专栏收录该内容

175 篇文章

订阅专栏

本文探讨了一种常见的INSERT语句使用错误，即在带有子查询的INSERT语句中错误地使用了VALUES关键字。通过一个具体例子说明了如何正确地执行此类INSERT操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

159.View the Exhibit and examine the structure of the CUSTOMERS table.
NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that
have the same data types and size as the corresponding columns in the CUSTOMERS table.
Evaluate the following INSERT statement:
INSERT INTO new_customers (cust_id, cust_name, cust_city)
VALUES(SELECT cust_id,cust_first_name' 'cust_last_name,cust_city
FROM customers

WHERE cust_id > 23004);

The INSERT statement fails when executed. What could be the reason?
A.The VALUES clause cannot be used in an INSERT with a subquery.
B.Column names in the NEW_CUSTOMERS and CUSTOMERS tables do not match.
C.The WHERE clause cannot be used in a subquery embedded in an INSERT statement.
D.The total number of columns in the NEW_CUSTOMERS table does not match the total number of columns in the CUSTOMERS table.
答案：A
解析：这种插入不需要values关键字