Re: insert/update

[Sasha Pachev]

"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