Re: conditional insert

Pau Marc Muñoz Torres, 05.09.2011 11:38:
> Hi follk
>
>   i trying  to performe a  conditional insert into a table, indeed, what i'm trying to do is not insert a record into
thetable if that record exist 
>
> googleling i found something like
>
>   insert into XX values (1,2,3) where not exist (select ....);
>
> but i'm having and error near where...
> anyone knows how do i can perfome this insert?

INSERT INTO xxx
SELECT 1,2,3
WHERE NOT EXISTS (SELECT ...)

Regards
Thomas