This one time, at band camp, Baron Schwartz <[EMAIL PROTECTED]> wrote:
> INSERT INTO item (`key`)
> SELECT CONCAT('my-item',
> (SELECT IF(COUNT(*) = 0, '', CONCAT('-', COUNT(*)))
>FROM item WHERE `key` LIKE 'my-item%'));
> Kevin, this design is not first normal form and will cause you
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 1
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 one time, at band camp, "Martin Gainty" <[EMAIL PROTECTED]> wrote:
> Kevin-
>
> Declare the column AUTO_INCREMENT
> http://lists.mysql.com/mysql/161930
You can auto increment a non INT field?
Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
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 reg
