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
