mysql remove auto_increment

show create table 对应字段

`id` bigint(20) NOT NULL AUTO_INCREMENT

现在重新 alter

alter table `dw`.`lesson` change id id bigint(20) NOT NULL;

这样就没有 auto_increment 了

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *