mysql已有数据表增加自增主键

mysql:

alter table `tbname` add `id` bigint not null auto_increment first, add primary key (`id`);