note 127622 added to pdo.exec

Note that with MySQL you can detect a DUPLICATE KEY with INSERT (1 = INSERT, 2 = UPDATE) : <?php // MySQL specific INSERT UPDATE-like syntax $sql = <<<SQL INSERT INTO customers SET id = {$pdo->quote($id)}, name = {$pdo->quote($name)}, address = {$pdo->quote($address)} AS new ON DUPLICATE KEY UPDATE name = new.name, address = new.address SQL; $result = $pdo->exec($sql); if ($result === 1) { // An INSERT of a new row has be done } elseif ($result === 2) { // An UPDATE of an existing row has be done } ---- Server IP: 45.112.84.4 Probable Submitter: 185.85.3.173 (proxied: 213.36.7.9) ---- Manual Page -- https://php.net/manual/en/pdo.exec.php Edit -- https://main.php.net/note/edit/127622 Del: integrated -- https://main.php.net/note/delete/127622/integrated Del: useless -- https://main.php.net/note/delete/127622/useless Del: bad code -- https://main.php.net/note/delete/127622/bad+code Del: spam -- https://main.php.net/note/delete/127622/spam Del: non-english -- https://main.php.net/note/delete/127622/non-english Del: in docs -- https://main.php.net/note/delete/127622/in+docs Del: other reasons-- https://main.php.net/note/delete/127622 Reject -- https://main.php.net/note/reject/127622 Search -- https://main.php.net/manage/user-notes.php