From: emierzwa
Date: May 5 2004 3:05pm
Subject: RE: if exists
List-Archive: http://lists.mysql.com/mysql/164888
Message-Id: <632F9ED6C21173418D24CD274E65F3810156568D@ntxboimbx04.micron.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Silently ignore duplicate index inserts...

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

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

I'm looking for something like

if not exists( select 1 from PERSON where NAME =3D '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