Mysql 'On Duplicate Key INSERT .... SELECT...'
- by calumbrodie
Hi, I'm looking for a way to do the following in mysql.
INSERT INTO category (cat_id,sku,description,color)
VALUES ('$cat_id','$sku','$description','$color')
ON DUPLICATE KEY UPDATE description=$description"
this works fine... but I want something further to happen if there is a duplicate key. I want to copy a row from the 'product' table to the 'categorized_products'...
AND INSERT categorized_products (a,b,c) SELECT a,b,c FROM products
WHERE products.cat = '$cat_id'
is there a way to do the INSERT...SELECT as part of the first query or do I need to evaluate the above with mysql_affected_rows ( 1 is updated and == 1 is inserted) and then run my second query.
Obviously the above will work but means another query and more LOC. Thanks!
