Re: conditional insert with values; insert into .. values(...) where not exist (....);
From: Peter Nilsson <airia_at_acay.com.au>
Date: Tue, 29 Apr 2008 20:27:31 -0700 (PDT)
Message-ID: <402c6339-c007-401e-a12d-aaed7ff917a2@i36g2000prf.googlegroups.com>
Date: Tue, 29 Apr 2008 20:27:31 -0700 (PDT)
Message-ID: <402c6339-c007-401e-a12d-aaed7ff917a2@i36g2000prf.googlegroups.com>
md wrote:
> This is what I wish I could to do.
>
> insert into table_x (a, b, c)
> values(1, 2, 3)
> where not exist (select * from table_x where a = 2);
>
> Thank you.
Look up 'insert when'.
-- PeterReceived on Tue Apr 29 2008 - 22:27:31 CDT