如果是ACESS,1楼是正解 如果是ORACLE,create table newtable as select * from oldtable ;
SELECT * INTO newtable FROM oldtable
空记录: SELECT 字段数 INTO newtable FROM oldtable where 1=2符合条件的记录: SELECT 字段数 INTO newtable FROM oldtable where 条件所有记录 SELECT 字段数 INTO newtable FROM oldtable
如果是ORACLE,create table newtable as select * from oldtable ;
SELECT 字段数 INTO newtable FROM oldtable where 1=2符合条件的记录:
SELECT 字段数 INTO newtable FROM oldtable where 条件所有记录
SELECT 字段数 INTO newtable FROM oldtable