Re: table with multiple primary key

[Rick James]

@Peter:

mysql> create table f619790(i int auto_increment);
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key
mysql> create table f619790(i int auto_increment, INDEX(i));
Query OK, 0 rows affected (0.08 sec)

Notice how it said it must be defined as a "key", and did not say "PRIMARY KEY".