List:General Discussion« Previous MessageNext Message »
From:bruce Date:August 11 2006 4:28am
Subject:insert/replace question...
View as plain text  
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...
replace into appTBL
             (appName, universityID)
              values(%s,%s)
              where foo != 66

and various combinations but i'm getting an error regarding the 'where'
clause...

i've searched the mysql site, as well as google, and can't quite figure out
how to accomplish this.. is there another, more efficient/better way to
resolve this...

any thoughts/comments...


thanks


Thread
insert/replace question...bruce11 Aug
  • Re: insert/replace question...Brent Baisley11 Aug
    • Re[2]: insert/replace question...Aleksandar Bradaric11 Aug