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

2024-10-09 11:22:58 浏览数 (4)

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`;

0 人点赞