On Thu, Mar 22, 2007 at 08:11:21AM -0400, Allen Schmidt Sr. wrote:
> Just use REPLACE instead of INSERT.
> If REPLACE statement is able to determine a unique value for a row and 
> sees that that unique value exists for a row, the valued will be 
> updated. If it does not exist, a new row will be inserted. This is what 
> I use with MySQL.

Or, depending on what you want, the INSERT...ON DUPLICATE KEY UPDATE
syntax can be used.

Note that both of these idioms are specific to MySQL and not portable
to other databases.



Paul Winkler
Zope maillist  -  Zope@zope.org
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-dev )

Reply via email to