条件1=1肯定成立,表示备份数据和表结构,1=2则不成立,只备份表结构
1.Sql Server
select * into newtableName from oldTableName Where 1=1; 备份表结构和数据
select * into newtableName from oldTableName Where 1=2; 备份表结构
- Oracle 3种方法
create table newTableName as select * from oldTableName where 1=1;备份表和数据
select * into newtableName from oldTableName Where 1=1; 备份表和数据
insert into newtableName select * from oldTableName Where 1=1; 备份表和数据
3.Mysql
create table newTableName as select * from oldTableName where 1=1;备份表和数据