Hi,
> REPLACE is a special INSERT/UPDATE combination where you
> dont specify a filter, it uses the primary key. If no existing record
> exists, it INSERTs a new one, otherwise it UPDATEs an existing one.
Just a quick note - REPLACE does not do any UPDATE. It is a
combination of DELETE (if t
t; <[EMAIL PROTECTED]>
To:
Sent: Friday, August 11, 2006 12:28 AM
Subject: insert/replace question...
hi.
i have the following that works... in that it does a replace on the row.
replace into appTBL
(appName, universityID)
values(%s,%s)...
i'm trying to fig
hi.
i have the following that works... in that it does a replace on the row.
replace into appTBL
(appName, universityID)
values(%s,%s)...
i'm trying to figure out how to do the replace on the row if a given column
is not equal to a certain value..
i've tried...
replac