Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Chris Peters
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Chris Peters@cf_chrispeters )

Andrew Duckett

Member since Dec 11, 2008

Recent Blog Comments By Andrew Duckett

  • MySQL Does Not Support IF / ELSE Statements In General SQL Work Flow

    Posted on Sep 2, 2008 at 5:00 PM

    Hey Ben, Check out INSERT ... ON DUPLICATE KEY UPDATE (I'm not sure how to post a link in comments - http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html ). Something like: INSERT INTO contact (id,name,email) VALUES (x,y,z) ON DUPLICATE KEY UPDATE 0=0; If you'd like to actually upd... read more »