登录注册搜索
1。复制空表结构 create table new_table as select * from old_table where 1=2;2。复制表(含记录) create table new_table as select * from old_table ;3。修改表的列名 alter table xxx rename column xx to yy;