insert into seniordrivers where drivedistanced>=5000 from drivers
insert into seniordrivers(drivedistanced) values from drivers where drivedistanced>=5000
insert into seniordrivers(drivedistanced) where values>=5000 from drivers
select * into seniordrivers from drivers where drivedistanced >=5000
INSERT INTO table_name VALUES (值1, 值2,....) 指定所要插入数据的列: INSERT INTO table_name (列1, 列2,...) VALUES (值1, 值2,....)SELECT INTO 语句从一个表中选取数据,然后把数据插入另一个表中。常用于创建表的备份复件或者用于对记录进行存档。
把所有的列插入新表 SELECT * INTO new_table_name [IN externaldatabase] FROM old_tablename
只把希望的列插入新表 SELECT column_name(s) INTO new_table_name [IN externaldatabase] FROM old_tablename