This is a simple question, but i've looked around and couldn't find the answer. how do i extract the number of affected rows from update/insert sql queries in zf2? the following code is working ni.... On duplicate key update statement. in other words, values(col_name) in the on duplicate key update clause refers to the value of col_name that would be inserted, had no duplicate-key conflict occurred.. I have to insert 100k+ record in the db and i have some memory issues. $_data is an array holding the arrays of data. i even increase the memory size but still got into problems.
Hi, i have a weird problem with insert on duplicate key update. we use the statement in a php projects based on the zend framework. the staments works fine on the test and production server, running php 5.3.3 and mysql 5.1.3 on linux.. As of zend framework 1.9, you can instantiate zend_db_table.this added benefit is that you do not have to extend a base class and configure it to do simple operations such as selecting, inserting, updating and deleteing on a single table. below is an example of the simplest of use cases.. It takes advantage of mysql's on duplicate key update feature. the patch is for the mysql pdo adapter -- other adapters would need to implement their own versions of these methods, even if that means looping through the data and performing separate inserts..
