ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be def

本文主要是介绍ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be def，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

        如下：

mysql> create table tbx(-> id int unsigned not null  auto_increment,-> score int not null-> );
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key
mysql> 

       什么意思呢？ 自增列只能有1列， 且这列必须为key,  如下便OK:

mysql> create table tbx(-> id int unsigned not null  auto_increment primary key,-> score int not null-> );
Query OK, 0 rows affected (0.01 sec)mysql> 

      good
   

这篇关于ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be def的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---