mysql新增自增id并填充

alter table t_area_list 
add column id int auto_increment PRIMARY key;
set @id :=0;
update t_area_list set id =(@id :=@id + 1);