nix, shell, perl, php, mysql and mac os x tips and tricks

Monday, September 10, 2007

Update column in a table whose values are NOT found in another table

UPDATE products_staging LEFT JOIN published ON products_staging.SKUID=published.skuid SET products_staging.PUBLISH = '0' WHERE published.skuid IS NULL

No comments:

Post a Comment