GoFuckYourself.com - Adult Webmaster Forum - View Single Post

psili · 10-26-2009, 06:36 PM

UPDATE TABLE_1 LEFT JOIN TABLE_2 ON TABLE_1.COLUMN_1= TABLE_2.COLUMN_2
SET TABLE_1.COLUMN = EXPR WHERE TABLE_2.COLUMN2 IS NULL

Sorry. Just lazy and posting from MySQL docs.

10-26-2009, 06:36 PM
psili Confirmed User Join Date: Apr 2003 Location: Loveland, CO Posts: 5,526	UPDATE TABLE_1 LEFT JOIN TABLE_2 ON TABLE_1.COLUMN_1= TABLE_2.COLUMN_2 SET TABLE_1.COLUMN = EXPR WHERE TABLE_2.COLUMN2 IS NULL Sorry. Just lazy and posting from MySQL docs. __________________ Your post count means nothing.