I would like to use
ON DUPLICATE KEY UPDATE in Zend Framework 1.5, is this possible?
INSERT INTO sometable (...) VALUES (...) ON DUPLICATE KEY UPDATE ...
I worked for Zend and specifically worked on Zend_Db quite a bit.
No, there is no API support for the
ON DUPLICATE KEY UPDATE syntax. For this case, you must simply use
query() and form the complete SQL statement yourself.
I do not recommend interpolating values into the SQL as harvejs shows. Use query parameters.
Edit: You can avoid repeating the parameters by using
$sql = "INSERT INTO sometable (id, col2, col3) VALUES (:id, :col2, :col3) ON DUPLICATE KEY UPDATE col2 = VALUES(col2), col3 = VALUES(col3)"; $values = array("id"=>1, "col2"=>327, "col3"=>"active");