MYSQL
CREATE TABLE IF NOT EXISTS new_table LIKE old_table;
INSERT INTO new_table_bak SELECT * FROM old_table; Oracle create table IF NOT EXISTS 备份表名 as select * from 需要备份的表 例：create table t_njfh_book_price1027 as select * from t_njfh_book_price 注：备份表名不用创建，系统自己创建
原文：https://www.cnblogs.com/littleboyck/p/11840120.html