mysql删除主键索引,删除索引语法

mysql删除主键索引,删除索引语法

### Incorrect table definition; there can be only one auto column and it must be defined as a key
## 更新id列,去掉 AUTO_INCREMENT
ALTER TABLE mytest_config_back MODIFY COLUMN `id` INT(11) NOT NULL;
## 删除主键索引 ALTER TABLE 表名 DROP INDEX 索引名称;
ALTER TABLE mytest_config_back DROP INDEX `PRIMARY`;

posted on 2024-05-22 06:26  oktokeep  阅读(3)  评论(0编辑  收藏  举报