mysql INSERT UPDATE — ON DUPLICATE KEY
28 апреля 2010
no comments
$sql = «INSERT INTO `subscription` (`email`, `id_language`, `id_currency`)
VALUES (‘».$email.»‘,».$language.»,».$currency.»)
ON DUPLICATE KEY UPDATE
`id_language`=VALUES(`id_language`),
`id_currency`=VALUES(`id_currency`)»;
http://i1t2b3.blogspot.com/2006/02/on-duplicate-key-update.html