At 08:41 14-11-2007, Lenny Shovsky wrote:
I'm running into some trouble getting replication working for AWL
tables, because there are many duplicate entries in AWL. I tried
creating the table as follows, adding a unique id number, but I got
this error message.
ERROR 1075 (42000) at line 1: Incorrect table definition; there can be
only one auto column and it must be defined as a key
What other column is this 'auto column' ?
Your auto_increment column should be the primary key.
I suggest reading about the (MySQL) issues with auto_increment if you
are doing replication.
Regards,
-sm