Latest Post

Error: No input file specified.

While trying to run a codeigniter app the other day I came across this error just after I had finished uploading the files and making the ne...

Wednesday, October 7, 2009

Example: mysql update with inner join

UPDATE product
INNER JOIN product_price
ON product.productId = product_price.productId
SET product_price.price = product_price.price * 1.5
WHERE product.dateCreated < '2009-10-23'

NOTE: This applies to MySQL version 4.0 or higher

Chitika Ads