List:General Discussion« Previous MessageNext Message »
From:emierzwa Date:May 5 2004 3:05pm
Subject:RE: if exists
View as plain text  
Silently ignore duplicate index inserts...

insert IGNORE into PERSON ( NAME ) values ( 'Test')

-----Original Message-----
From: Gerhard Gaupp [mailto:g.gaupp@stripped] 

I'm looking for something like

if not exists( select 1 from PERSON where NAME = 'Test' ) then
   insert into PERSON ( NAME ) values ( 'Test');
end if;

I did it with Sybase Database.
I need to get Data from Excel and have to be shure that there is no data
more than once in the table.
So I have to generate a script with test, if this data is in teh table
yet, or not, before inserting.

Did You Understand? Sorry for my English

Greetings from Germany

Scheduled queriesJuan Riera18 Mar
  • Patch: Re: Unknown errorMichael Widenius8 Nov
Re: Scheduled queriesEd Carp18 Mar
RE: if existsemierzwa5 May
  • Re: if existsMichael Stassen5 May