Re: conditional insert with values; insert into .. values(...) where
by Peter Nilsson <airia@[EMAIL PROTECTED]
>
Apr 29, 2008 at 08:27 PM
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'.
--
Peter