Posted by laredotornado@zipmail.com on 08/07/07 15:38

Hi,

I'm running MySQL 5.0 lon Linux. I have two tables ...


PRODUCTS
-----------------
ID INTEGER NOT NULL
PRICE FLOAT UNSIGNED NOT NULL
PRIMARY KEY (ID)


CUSTOM_PRICES
---------------------------
ID INTEGER NOT NULL
PRODUCT_ID INTEGER NOT NULL
PRICE FLOAT UNSIGNED NOT NULL
PRIMARY KEY (ID)
FOREIGN KEY PRODUCT_ID REFERENCES PRODUCTS(ID)


The table "CUSTOM_PRICES" will have a subset of products from the
products table. What I want to do is update the price in the PRODUCTS
table with the corresponding entry from the CUSTOM_PRICES table,
assuming there is one. If there is not a corresponding entry in the
CUSTOM_PRICES table, I would like the price value in the PRODUCTS
table to remain unchanged.


How can I do this in a single UPDATE statement?


Thanks, - Dave

• Next in forum: Re: How can I write an SQL statement for this situation?
• Prev in forum: Re: phpBB and access to MySQL database
• Thread view: How can I write an SQL statement for this situation?

[Reply to this message]