没有好办法
alter table table_name add new_name number;
update table_name set new_name=old_name;
alter table table_name drop column old_name;或者
create table tbname_temp as
select col1,old_name new_name,col_.. from table_name;
drop table table_name;
rename tbname_temp to table_name;
alter table table_name add new_name number;
update table_name set new_name=old_name;
alter table table_name drop column old_name;或者
create table tbname_temp as
select col1,old_name new_name,col_.. from table_name;
drop table table_name;
rename tbname_temp to table_name;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货