插入数据到数据库中的时候,常用的语句如下:
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
?