Re: If Exists update else insert

2004-02-18 Thread Victoria Reznichenko
"Juan E Suris" <[EMAIL PROTECTED]> wrote: > I need to do something similar to replace, but can't figure out how to do it. > > Here's my table: > user varchar(15) PRI > cnt int(11) > > I want to increment cnt for user if it exists, else insert a row with cnt=1. I tried > the following, but mysql

Re: If exists UPDATE else INSERT

2001-01-26 Thread Artem Koutchine
I've seen something about this in the manual. At the moment the problem was how to call such an SQL command (like REPLACE for DELETE/INSERT). I wonder if it was implemented in 3.23.32 or is it only in 4.x? - Original Message - From: "Jan Willamowius" <[EMAIL PROTECTED]> To: <[EMAIL PROTEC