备份数据库表
复制备份表(包含字段和数据,不包含表主键,索引和约束): create table table_name2 as select * from table_name1
复制备份表(包含字段和数据和表结构):
create table table_name2 like select * from table_name1
insert into table_name2 select * from table_name1
备份数据库表
复制备份表(包含字段和数据,不包含表主键,索引和约束): create table table_name2 as select * from table_name1
复制备份表(包含字段和数据和表结构):
create table table_name2 like select * from table_name1
insert into table_name2 select * from table_name1