通過(guò) SQL,您可以從一個(gè)表復(fù)制信息到另一個(gè)表。
SELECT INTO 語(yǔ)句從一個(gè)表復(fù)制數(shù)據(jù),然后把數(shù)據(jù)插入到另一個(gè)新表中。
SQL SELECT INTO 語(yǔ)句
SELECT INTO 語(yǔ)句從一個(gè)表復(fù)制數(shù)據(jù),然后把數(shù)據(jù)插入到另一個(gè)新表中。
SQL SELECT INTO 語(yǔ)法
我們可以復(fù)制所有的列插入到新表中:
//SELECT *
//INTO newtable [IN externaldb]
//FROM table1;
//INTO newtable [IN externaldb]
//FROM table1;
或者只復(fù)制希望的列插入到新表中:
SELECT column_name(s)
INTO newtable [IN externaldb]
FROM table1;
INTO newtable [IN externaldb]
FROM table1;
![]() | 提示:新表將會(huì)使用 SELECT 語(yǔ)句中定義的列名稱和類型進(jìn)行創(chuàng)建。您可以使用 AS 子句來(lái)應(yīng)用新名稱。 |
---|
SQL SELECT INTO 實(shí)例
創(chuàng)建 Customers 的備份復(fù)件:
SELECT *
INTO WebsitesBackup2016
FROM Websites;
INTO WebsitesBackup2016
FROM Websites;
請(qǐng)使用 IN 子句來(lái)復(fù)制表到另一個(gè)數(shù)據(jù)庫(kù)中:
SELECT *
INTO WebsitesBackup2016 IN 'Backup.mdb'
FROM Websites;
INTO WebsitesBackup2016 IN 'Backup.mdb'
FROM Websites;
只復(fù)制一些列插入到新表中:
SELECT name,
url
INTO WebsitesBackup2016
FROM Websites;
INTO WebsitesBackup2016
FROM Websites;
只復(fù)制中國(guó)的網(wǎng)站插入到新表中:
SELECT *
INTO WebsitesBackup2016
FROM Websites
WHERE country='CN';
INTO WebsitesBackup2016
FROM Websites
WHERE country='CN';
復(fù)制多個(gè)表中的數(shù)據(jù)插入到新表中:
SELECT Websites.name, access_log.count, access_log.date
INTO WebsitesBackup2016
FROM Websites
LEFT JOIN access_log
ON Websites.id=access_log.site_id;
INTO WebsitesBackup2016
FROM Websites
LEFT JOIN access_log
ON Websites.id=access_log.site_id;
提示:SELECT INTO 語(yǔ)句可用于通過(guò)另一種模式創(chuàng)建一個(gè)新的空表。只需要添加促使查詢沒(méi)有數(shù)據(jù)返回的 WHERE 子句即可:
SELECT *
INTO newtable
FROM table1
WHERE 1=0;
INTO newtable
FROM table1
WHERE 1=0;