GoFuckYourself.com - Adult Webmaster Forum - View Single Post

Dragon Curve · 02-10-2005, 10:06 PM

Btw, as of MySQL 4.1.1 you can also use VALUES(Column) in the ON DUPLICATE KEY UPDATE .. i.e.

INSERT INTO Reports VALUES (DATE(NOW()), 1) ON DUPLICATE KEY UPDATE ReportValue = VALUES(ReportValue) + 1;

very useful - not to mention fast

02-10-2005, 10:06 PM
Dragon Curve Confirmed User Join Date: Oct 2002 Posts: 252	Btw, as of MySQL 4.1.1 you can also use VALUES(Column) in the ON DUPLICATE KEY UPDATE .. i.e. INSERT INTO Reports VALUES (DATE(NOW()), 1) ON DUPLICATE KEY UPDATE ReportValue = VALUES(ReportValue) + 1; very useful - not to mention fast