Insert or update if unique key already exist - MySQL Snipplr Social Repository

Revision: 19617

at October 27, 2009 10:42 by Zwendel

Initial Code

INSERT INTO `tableName`
VALUES (?,?,?,'-1',?,'0')
ON DUPLICATE KEY
UPDATE `id` = ?, `foo` = ?, `bar` = ?

Initial URL

Initial Description

Initial Title

Insert or update if unique key already exist

Initial Tags

update

Initial Language

MySQL