刘振明

摘要： //主键alter table tabelname add new_field_id int(5) unsigned default 0 not null auto_increment ,add primary key (new_field_id);//删除列alter table t2 drop column c;//重命名列alter table t1 change a b integer;//改变列的类型alter table t1 change b b bigint not null;alter table infos change list list tinyint not null 阅读全文