..@oracle.com]
Gesendet: Montag, 6. September 2010 20:03
An: Thorsten Heymann
Cc: mysql@lists.mysql.com
Betreff: Re: Dup Key Error Messages
Hi Thorsten, all!
Thorsten Heymann wrote:
> Hi,
>
> First, I'm new to this mailing list, hopefully I'll do my post the *right*
> way
tompk...@googlemail.com]
Gesendet: Montag, 6. September 2010 15:06
An: Thorsten Heymann
Cc: mysql@lists.mysql.com
Betreff: Re: Dup Key Error Messages
Hi
You have a PRIMARY KEY of just the id field like PRIMARY KEY ( `id` ). You
need both ip and type to be the primary key
Cheers
Neil
On Mon, Sep 6, 2010
Not the answer I hoped to get but, thanks Carsten!
-Ursprüngliche Nachricht-
Von: Carsten Pedersen [mailto:cars...@bitbybit.dk]
Gesendet: Montag, 6. September 2010 15:17
An: Thorsten Heymann
Cc: mysql@lists.mysql.com
Betreff: Re: Dup Key Error Messages
On Mon, 6 Sep 2010 15:02:24 +0200
Hi,
First, I'm new to this mailing list, hopefully I'll do my post the *right* way.
I've a problem with duplicate key error messages. In my application I use a
table with multiple unique keys (ip_addr and print_name). Lets use this example:
Table `device` :
CREATE TABLE `device` (
`id` INT NOT
