INSERT INTO table1(id, name, address) VALUES(1, ygl, ‘beijing') 適用于T-sql和PL/SQL
SELECT id, name, address INTO table2 FROM table1 自動創建table2，T-sql用法
INSERT INTO table2(id, name, address) SELECT id, name, address FROM table1

INSERT INTO table2 SELECT id, name, address FROM table1