Loading

Sunday, April 17, 2005

Resolving ERROR 1075: Incorrect table definition; There can only be one auto column and it must be defined as a key

mysql> alter table test add orig_order int unsigned auto_increment;
ERROR 1075: Incorrect table definition; There can only be one auto column and it must be defined as a key
mysql> alter table test add orig_order int unsigned auto_increment, add key(orig_order);
Query OK, 1221 rows affected (0.10 sec)
Records: 1221 Duplicates: 0 Warnings: 0

SHARE TWEET

Thank you for reading this article Resolving ERROR 1075: Incorrect table definition; There can only be one auto column and it must be defined as a key With URL http://x-tutorials.blogspot.com/2005/04/resolving-error-1075-incorrect-table.html. Also a time to read the other articles.

0 comments:

Write your comment for this article Resolving ERROR 1075: Incorrect table definition; There can only be one auto column and it must be defined as a key above!