[Teach Youself SQL in 10 Minutes] inserting data

iteye_1678

于 2011-04-14 11:08:19 发布

阅读量122

点赞数

CC 4.0 BY-SA版权

分类专栏： db 文章标签： DB2

本文链接：https://blog.youkuaiyun.com/iteye_1678/article/details/82044745

db 专栏收录该内容

19 篇文章

订阅专栏

本文介绍了使用SQL进行数据插入及从一个表复制到另一个表的方法。通过INSERT...SELECT语句可以实现数据过滤插入，而使用SELECT...INTO语句则能够轻松完成表间的数据复制。

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

1. Inserting Retrieved Data

INSERT INTO Customers(cust_id,

    cust_contact,

    cust_email,

    cust_name,

    cust_address,

    cust_city,

    cust_state,

    cust_zip,

    cust_country)

SELECT cust_id,

    cust_contact,

    cust_email,

    cust_name,

    cust_address,

    cust_city,

    cust_state,

    cust_zip,

    cust_country

FROM CustNew;

The SELECT statement used in an INSERT SELECT can include a WHERE clause to filter the data to be inserted.

Column Names in INSERT SELECT This example uses the same column names in both the INSERT and SELECT statements for simplicity's sake. But there is no requirement that the column names match. In fact, the DBMS does not even pay attention to the column names returned by the SELECT. Rather, the column position is used, so the first column in the SELECT (regardless of its name) will be used to populate the first specified table column, and so on.

2. Copying from One Table to Another

SELECT *

INTO CustCopy

FROM Customers;

【Not Supported by DB2 】