原文链接:http://www.fengyachao.com/archives/69
1.原字段没数据
alter table tb_test modify col integer;
2.原字段有数据
alter table tb_test add col_temp integer;
update tb_test set col_temp=col;
alter table tb_test drop column col;
alter table tb_test rename column col_temp to col;