区别:select (column) into from要求现表还未创建,insert into要求现表已经创建,且字段类型与原表相同或可以自动转换
语法:
select (column) into new_table from old_table
insert into new_table (column) from select (column) from old_table
区别:select (column) into from要求现表还未创建,insert into要求现表已经创建,且字段类型与原表相同或可以自动转换
语法:
select (column) into new_table from old_table
insert into new_table (column) from select (column) from old_table