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
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!