Re: SQL Update 2.6.0 -> 2.6.1

From: SM <sm_at_resistor.net>
Date: Wed, 27 Jun 2012 22:21:56 -0700

Hi Andreas,
At 22:11 27-06-2012, Andreas Schulze wrote:
>mysql> ALTER TABLE messages DROP PRIMARY KEY, ADD PRIMARY
>KEY(reporter,jobid, msgtime);
>ERROR 1075 (42000): Incorrect table definition; there can be only
>one auto column and it must be
>defined as a key

My mistake is that I did not see "id int unsigned not null auto_increment".

>The winner is MURRAY!

:-)

Regards,
-sm
Received on Thu Jun 28 2012 - 05:22:26 PST