Database Registration

It may be surprisingly difficult.

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

If you get an error message like "The key setting is not working properly," it seems that the key setting is not working properly.
It seems that databases that use auto_increment do.

http://d.hatena.ne.jp/kkz_tech/20101004/1286172505