#删除id列 alter table es_member drop member_id; #新增id列,设为主键,并自增 ALTER TABLE es_member ADD member_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT FIRST;