 | | | append on insert | append on insert 2007-11-03 - By Brent Baisley
Back
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 (See http://tem-2.ora-code.com)
> or even my-item-123 (See http://tem-123.ora-code.com) 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?
> unsub=brenttech@(protected)
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
|