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

Monday, September 24, 2007

Mirror an entire site, dynamic or not, using wget

wget --wait=5 --limit-rate=200K -m -k -E -U 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.61 Safari/537.36' --no-check-certificate https://www.47thmain.com/

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