数据库：Incorrect table definition； there can be only one auto column and it must be defined as a key报错

最新推荐文章于 2024-08-23 13:58:49 发布

置顶知无涯学无尽

最新推荐文章于 2024-08-23 13:58:49 发布

阅读量2.1k

点赞数 3

分类专栏：数据库管理排障集合文章标签： mysql 数据库 sql oracle

本文链接：https://blog.csdn.net/CN_LiTianpeng/article/details/108517484

版权

数据库管理同时被 2 个专栏收录

31 篇文章 1 订阅

订阅专栏

排障集合

19 篇文章 1 订阅

订阅专栏

错误提示：ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key

错误原因：id字段指定了auto_increment类型，因此主键只能指定id字段。


mysql> create table llll (id int(10) not null auto_increment,user char(16) not null,primary key (user));
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key

解决办法：主键指定id，或者删除auto_increment语句

mysql> create table llll (id int(10) not null,user char(16) not null,primary key (user));
Query OK, 0 rows affected (0.00 sec)

mysql> show keys from llll;
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| llll  |          0 | PRIMARY  |            1 | user        | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
1 row in set (0.00 sec)