1.复制整个表:
CREATE TABLE new_table SELECT * FROM old_table;
2.只复制表结构,不复制数据
CREATE TABLE new_table SELECT * FROM old_table where 0;
1.复制整个表:
CREATE TABLE new_table SELECT * FROM old_table;
2.只复制表结构,不复制数据
CREATE TABLE new_table SELECT * FROM old_table where 0;
转载于:https://my.oschina.net/snxun/blog/821823