List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:June 25 1999 1:08am
Subject:Re: insert/update
View as plain text  
"Douglas B. Jones" wrote:
> 
> Hi,
> 
> If I have a row that does not exist yet and I do an update
> with all the columns of the row, does it get inserted? If so,
> what happens if I only do some columns? Are the other set to
> a default value?
> 
> Thanks,
> Cheers,
> Douglas
> 

UPDATE can happen only on the already existing rows. If a row is not
there UPDATE will never find it and do nothing.

-- 
Sasha Pachev
http://www.sashanet.com
Thread
insert/updateDouglas B. Jones25 Jun
  • Re: insert/updateSasha Pachev25 Jun