In the current version of mysql 3.23 it is not possible to update a key to the same value you have inserted. I know that this formerly worked.

BTW: You have done a really great job. :-)

# mysqladmin version mysqladmin Ver 8.12 Distrib 3.23.28-gamma, for pc-linux-gnu on i586 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license

Server version 3.23.28-gamma-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 4 hours 49 min 33 sec

mysql> desc texts; +-------------+------------------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +-------------+------------------+------+-----+---------+-------+---------------------------------+ | aid | int(10) unsigned | | PRI | 0 | | select,insert,update,references | | contenttype | varchar(40) | | PRI | | | select,insert,update,references | | a_text | text | | | | | select,insert,update,references | +-------------+------------------+------+-----+---------+-------+---------------------------------+

mysql> UPDATE texts SET a_text='BMW 320i, EZ 10/95, 96 tkm, d.blau, Klima, ESSD, Servo, ZV, ABS, VB 24.500.- Telefon:xxxx', aid=17732, contenttype='text/text' # ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^here it is! WHERE aid = 17732 AND contenttype = 'text/text';

ERROR 1062: Duplicate entry '17732-text/text' for key 3

mysql> update texts seT a_text='BMW 320i, EZ 10/95, 96 tkm, d.blau, Klima, ESSD, Servo, ZV, ABS, VB 24.500.- Telefon:xxxx' WHERE aid = 17732 AND contenttype = 'text/text';

Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0