SQL INSERT INTO SELECT 语句-育师

SQL INSERT INTO SELECT 语句

通过 SQL，您可以从一个表复制信息到另一个表。

INSERT INTO SELECT 语句从一个表复制数据，然后把数据插入到一个已存在的表中。

SQL INSERT INTO SELECT 语句

INSERT INTO SELECT 语句从一个表复制数据，然后把数据插入到一个已存在的表中。目标表中任何已存在的行都不会受影响。

SQL INSERT INTO SELECT 语法

我们可以从一个表中复制所有的列插入到另一个已存在的表中：

INSERT INTO table2
SELECT * FROM table1;

或者我们可以只复制指定的列插入到另一个已存在的表中：

INSERT INTO table2
(column_name(s))
SELECT column_name(s)
FROM table1;

演示数据库

在本教程中，我们将使用 RUNOOB 样本数据库。

vk.com/topic-234756933_54531892
vk.com/topic-234777846_54602277
vk.com/topic-234777971_55830501
vk.com/topic-234777967_55566569
vk.com/topic-234777908_54732739
vk.com/topic-234757139_54979505
vk.com/topic-234762548_54732738
vk.com/topic-234777873_54531891
vk.com/topic-234777957_55566568
vk.com/topic-234777925_54124723
vk.com/topic-234777935_54124722
vk.com/topic-234777787_55566567
vk.com/topic-234777924_54241475
vk.com/topic-234756933_54531890
vk.com/topic-234777969_54979504
vk.com/topic-234777846_54602276
vk.com/topic-234777971_55830500
vk.com/topic-234777908_54732736
vk.com/topic-234757139_54979503
vk.com/topic-234251396_54602275
vk.com/topic-234762548_54732734
vk.com/topic-234466620_55335775
vk.com/topic-234777928_54732735
vk.com/topic-234777935_54124721
vk.com/topic-234777924_54241473
vk.com/topic-234756933_54531889
vk.com/topic-234777969_54979502
vk.com/topic-234777923_54531888
vk.com/topic-234777908_54732733
vk.com/topic-234777926_54602274
vk.com/topic-234251396_54602273
vk.com/topic-234466620_55335773
vk.com/topic-234777928_54732732
vk.com/topic-234756911_55830499
vk.com/topic-234777937_55566566
vk.com/topic-234777924_54241472
vk.com/topic-234756933_54531887
vk.com/topic-234777969_54979501
vk.com/topic-234777923_54531886
vk.com/topic-234777926_54602272
vk.com/topic-234251396_54602271
vk.com/topic-234466620_55335771
vk.com/topic-234777913_54531884
vk.com/topic-234756911_55830498
vk.com/topic-234466708_54732731
vk.com/topic-234777924_54241470
vk.com/topic-234761493_54531883
vk.com/topic-234777969_54979500
vk.com/topic-234777905_54124719
vk.com/topic-234777926_54602269
vk.com/topic-234251396_54602270
vk.com/topic-234777952_54902561
vk.com/topic-234466620_55335770
vk.com/topic-234777913_54531881
vk.com/topic-234251298_54732730
vk.com/topic-234756911_55830495
vk.com/topic-234777912_54902560
vk.com/topic-234762356_54602268
vk.com/topic-234777924_54241469
vk.com/topic-234466708_54732729
vk.com/topic-234761472_54902559
vk.com/topic-234777969_54979499
vk.com/topic-234761493_54531880
vk.com/topic-234777905_54124718
vk.com/topic-234251396_54602267
vk.com/topic-234777927_55566564
vk.com/topic-234777926_54602266
vk.com/topic-234777957_55566563
vk.com/topic-234777952_54902558
vk.com/topic-234766259_54979497
vk.com/topic-234466620_55335769
vk.com/topic-234777925_54124717
vk.com/topic-234251298_54732728
vk.com/topic-234777913_54531879
vk.com/topic-234766256_54602265
vk.com/topic-234777912_54902557
vk.com/topic-234756911_55830494
vk.com/topic-234777937_55566562
vk.com/topic-234762356_54602264
vk.com/topic-234466708_54732727
vk.com/topic-234761472_54902555
vk.com/topic-234777971_55830493
vk.com/topic-234761493_54531878
vk.com/topic-234777905_54124716
vk.com/topic-234777873_54531877
vk.com/topic-234777927_55566561
vk.com/topic-234777957_55566560
vk.com/topic-234777926_54602263
vk.com/topic-234777952_54902554
vk.com/topic-234766259_54979496
vk.com/topic-234777925_54124715
vk.com/topic-234777913_54531876
vk.com/topic-234251298_54732726
vk.com/topic-234766256_54602262
vk.com/topic-234777935_54124714
vk.com/topic-234777787_55566559
vk.com/topic-234756911_55830492
vk.com/topic-234777912_54902553
vk.com/topic-234762356_54602261
vk.com/topic-234777937_55566558
vk.com/topic-234466708_54732725
vk.com/topic-234761472_54902552
vk.com/topic-234777971_55830491
vk.com/topic-234777846_54602260
vk.com/topic-234761493_54531874
vk.com/topic-234777843_54531875
vk.com/topic-234777908_54732724
vk.com/topic-234762548_54732723
vk.com/topic-234777905_54124713
vk.com/topic-234777873_54531873
vk.com/topic-234777927_55566557
vk.com/topic-234777928_54732722
vk.com/topic-234777957_55566556
vk.com/topic-234766259_54979494
vk.com/topic-234251298_54732721
vk.com/topic-234777952_54902551
vk.com/topic-234766256_54602259
vk.com/topic-234777925_54124712
vk.com/topic-234777935_54124711
vk.com/topic-234777787_55566555
vk.com/topic-234777875_54124710
vk.com/topic-234250764_54241468
vk.com/topic-234777913_54531872
vk.com/topic-234777912_54902550
vk.com/topic-234777937_55566554
vk.com/topic-234762356_54602258
vk.com/topic-234466708_54732720
vk.com/topic-234761472_54902549
vk.com/topic-234777971_55830490
vk.com/topic-234777846_54602257
vk.com/topic-234761493_54531870
vk.com/topic-234252226_54602256
vk.com/topic-234777908_54732718
vk.com/topic-234762548_54732719
vk.com/topic-234777905_54124709
vk.com/topic-234756700_55335767
vk.com/topic-234777873_54531869
vk.com/topic-234777927_55566553
vk.com/topic-234777928_54732717
vk.com/topic-234766259_54979493
vk.com/topic-234251298_54732716
vk.com/topic-234777957_55566552
vk.com/topic-234766256_54602255
vk.com/topic-234777925_54124708
vk.com/topic-234777886_54602254
vk.com/topic-234777787_55566551
vk.com/topic-234777907_55566550
vk.com/topic-234777935_54124707
vk.com/topic-234777875_54124706
vk.com/topic-234777912_54902547
vk.com/topic-234777937_55566549
vk.com/topic-234762356_54602253
vk.com/topic-234466708_54732715
vk.com/topic-234756933_54531868
vk.com/topic-234761472_54902546
vk.com/topic-234777923_54531867
vk.com/topic-234777846_54602252
vk.com/topic-234777971_55830489
vk.com/topic-234252226_54602251
vk.com/topic-234762548_54732714
vk.com/topic-234777908_54732713
vk.com/topic-234756700_55335766
vk.com/topic-234777927_55566548
vk.com/topic-234777873_54531866
vk.com/topic-234777876_54602250
vk.com/topic-234777928_54732712
vk.com/topic-234766259_54979492
vk.com/topic-234777957_55566547
vk.com/topic-234766256_54602249
vk.com/topic-234777925_54124705
vk.com/topic-234777886_54602248
vk.com/topic-234777952_54902545
vk.com/topic-234777787_55566546
vk.com/topic-234777907_55566545
vk.com/topic-234777935_54124704
vk.com/topic-234777875_54124703
vk.com/topic-234777937_55566544
vk.com/topic-234756933_54531865
vk.com/topic-234777887_55566543
vk.com/topic-234777923_54531864
vk.com/topic-234777971_55830488
vk.com/topic-234777846_54602247
vk.com/topic-234777924_54241466
vk.com/topic-234252226_54602246
vk.com/topic-234762548_54732711
vk.com/topic-234777908_54732709
vk.com/topic-234756700_55335765
vk.com/topic-234777584_54241465
vk.com/topic-234777873_54531863
vk.com/topic-234777928_54732710
vk.com/topic-234466620_55335764
vk.com/topic-234777957_55566542
vk.com/topic-234777897_55566541
vk.com/topic-234777886_54602245
vk.com/topic-234777787_55566540
vk.com/topic-234777913_54531862
vk.com/topic-234777935_54124702
vk.com/topic-234777875_54124701
vk.com/topic-234756933_54531861
vk.com/topic-234777887_55566539

下面是选自 "Websites" 表的数据：

+----+--------------+---------------------------+-------+---------+ | id | name | url | alexa | country | +----+--------------+---------------------------+-------+---------+ | 1 | Google | https://www.google.cm/ | 1 | USA | | 2 | 淘宝 | https://www.taobao.com/ | 13 | CN | | 3 | 菜鸟教程 | http://www.runoob.com/ | 4689 | CN | | 4 | 微博 | http://weibo.com/ | 20 | CN | | 5 | Facebook | https://www.facebook.com/ | 3 | USA | | 7 | stackoverflow | http://stackoverflow.com/ | 0 | IND | +----+---------------+---------------------------+-------+---------+

下面是 "apps" APP 的数据：

mysql> SELECT * FROM apps; +----+------------+-------------------------+---------+ | id | app_name | url | country | +----+------------+-------------------------+---------+ | 1 | QQ APP | http://im.qq.com/ | CN | | 2 | 微博 APP | http://weibo.com/ | CN | | 3 | 淘宝 APP | https://www.taobao.com/ | CN | +----+------------+-------------------------+---------+ 3 rows in set (0.00 sec)