建一个和原表一样的备份表(包括数据)或表已经有了,那末倒数据的sql
Oralce:create table new_table as (select * from old_table)
sql server:
select * into new_table from old_table
db2:
create table new_table like old_table;
insert into new_table select * from old_table;
如果表已经有了,那末倒数据的sql为:
oracle:
insert into tablea_bak select * fromtablea
页:
[1]