sql表备份

sql表备份

1、sql server

• 语句：select * into 备份后表名 from 原表名

--全表备份
select * into code_bak20230302 
from code;

--备份部分列
select column1，column2，...into code_bak20230302a
from code;

-- 备份满足一定条件的
select * into code_bak20230302 
from code
where cclass='资产';

2、oracle数据库

• 语句：create table [备份后表名] as select * from [原表名]

--创建表备份
create table bd_jobbasfil_bk20230302 
as select * from bd_jobbasfil; 
--恢复表备份
truncate table org_group;
insert into org_group select * from bd_jobbasfil_bk20230302;