SQL INSERT INTO SELECT 語句
INSERT INTO SELECT 語句從一個表復(fù)制數(shù)據(jù)，然后把數(shù)據(jù)插入到一個已存在的表中。目標(biāo)表中任何已存在的行都不會受影響。

INSERT INTO Websites (name, country)
SELECT app_name, country FROM apps;

INSERT INTO Websites (name, country)
SELECT app_name, country FROM apps
WHERE id=1;

INSERT INTO TABLE1 (PK_ID, PRODUCT_ID, IMAGE_CODE, IMAGE_SCENE, REQUIRED, RAW_CREATE_USER, RAW_CREATE_TIME, RAW_UPDATE_USER, RAW_UPDATE_TIME)
SELECT MD5(UUID()) t2.PRODUCT_ID, 'ID_CARD_BACK', '1', '1', 'SYS', NOW(), 'SYS', now() FROM TABLE2 t2;