News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Eran Galperin's Blog:
Multiple row operations in MySQL / PHP
May 14, 2009 @ 09:35:35

Eran Galperin has made a recent post about performing multiple row operations in MySQL - inserts and updates.

Multiple row operations are in common use in a normalized application databases as one database entity is often linked to multiple sub-entities (for example a user and his tags). [...] Too often I've seen such queries ran in long loops one at a time, which is very bad for performance (as I will show here) and sometimes equally bad for integrity (if the process is interrupted). So what are the alternatives?

His alternatives include concatenation of values for an insert (rather than looping) and updating the information with a "ON DUPLICATE KEY UPDATE" statement or, for multiple tables, using a join.

0 comments voice your opinion now!
tutorial insert update mysql


blog comments powered by Disqus

Similar Posts

Christopher Kunz's Blog: Building PHP with cURL and libmysqlclient5

Ilia Alshanetsky's Blog: MySQL Binaries and cURL/http extensions in PHP

DevShed: Inserting, Updating and Deleting Database Rows with Code Igniter

phpRiot.com: Zend Framework 101: Zend_Cache

DevShed: Iterators in the Simplest Sense - Traversing Different Data Structures


Community Events





Don't see your event here?
Let us know!


symfony community framework api version podcast conference list interview unittest voicesoftheelephpant configure series composer release language laravel tool introduction opinion

All content copyright, 2015 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework