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')

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

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

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