append on insert 2007-11-03 - By Kevin Waterson
Back
This one time, at band camp, Baron Schwartz <baron@(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 trouble.
> Consider what will happen if you insert my-item, my-item, and then my-ite.
I am aware of the break in 1NF but need use the item_name as a key. I was hoping
MySQL had some sort of sequence available to auto append to similar keys.
I could of course check if the key exists, and then change the value in the
application layer to my-item-2 (See http://tem-2.ora-code.com), but was hoping to do it in a single query.
Kind regards
kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
