You would need to have an auto_increment field and your primary key
would be the item id (or what you call it) field + the auto_increment
field. Mysql will then handle incrementing the field if there is
already a record with the same item id. Usually the auto_increment
field will contain 1. This gives you a unique sequence for each
"group" of records. I'm almost positive this only works on MyISAM
fields since InnoDB gets the increment number once on startup not on
insert.
On Nov 2, 2007, at 8:31 PM, Kevin Waterson wrote:
I have a table of item
I wish to have the value of the item incremented if there is a
duplicate.
I looked at ON DUPLICATE KEY UPDATE but this modifies the exsisting
value.
If the item is my-item and this already exists, I need to make it
my-item-2
or even my-item-123 where 123 is the key.
Kind regards
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]