Question

如何修改mysql主键的值为自增

Answer 1

-- 创建表CREATE TABLE `t2` ( `code` varchar(100) DEFAULT NULL,) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- 添加主键ALTER TABLE `t2` ADD COLUMN `ID` int(10) NOT NULL AUTO_INCREMENT AFTER `code`,ADD PRIMARY KEY (`id`)如何修改mysql主键的值为自增

Answer 2

id Int primary key auto_increment,

追答

麻烦给个采纳