Hi all,
I need to insert a row to mysql table if the corresponding data not exist,
if it exist i need to update the row.
Can we do it using a single Z SQL method.
Many thanks
Anz
___
Zope maillist - Zope@zope.org
Hi all,
I need to insert a row to mysql table if the corresponding data not
exist, if it exist i need to update the row.
Can we do it using a single Z SQL method.
Yes, if your ZSQL will call stored procedure that will handle this logic.
Otherwise, I think you can't (but I might be wrong).
Remil Mathew schrieb:
Hi all,
I need to insert a row to mysql table if the corresponding data not
exist, if it exist i need to update the row.
Can we do it using a single Z SQL method.
Well thats not business of ZSQL methods but rather
stuff you do with the instruments of your database.
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.
Allen
Tino Wildenhain wrote:
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