insert and deletind dublicating

2002-09-19 Thread Savaidis
Hello! I have to add a .sql file from MySQL-Front (insert into mytable ('0','asdf',ecc)) that containts some dublicates in the unic key. How can I do this and later to delere the dublicate records? The unic key has 3 string fields segments. Thanks! Makis

re: insert and deletind dublicating

2002-09-19 Thread Victoria Reznichenko
Savaidis, Thursday, September 19, 2002, 12:06:47 PM, you wrote: S I have to add a .sql file from MySQL-Front S (insert into mytable ('0','asdf',ecc)) S that containts some dublicates in the unic key. S How can I do this and later to delere the dublicate records? S The unic key has 3

Re: insert and deletind dublicating

2002-09-19 Thread Paul DuBois
At 12:06 +0300 9/19/02, Savaidis wrote: Hello! I have to add a .sql file from MySQL-Front (insert into mytable ('0','asdf',ecc)) that containts some dublicates in the unic key. That sounds self-contradictory. How can I do this and later to delere the dublicate records? The unic key

RE: insert and deletind dublicating

2002-09-19 Thread Savaidis
, September 19, 2002 5:10 PM To: Savaidis; mysql list Subject: Re: insert and deletind dublicating At 12:06 +0300 9/19/02, Savaidis wrote: Hello! I have to add a .sql file from MySQL-Front (insert into mytable ('0','asdf',ecc)) that containts some dublicates in the unic key. That sounds

RE: insert and deletind dublicating

2002-09-19 Thread Paul DuBois
PM To: Savaidis; mysql list Subject: Re: insert and deletind dublicating At 12:06 +0300 9/19/02, Savaidis wrote: Hello! I have to add a .sql file from MySQL-Front (insert into mytable ('0','asdf',ecc)) that containts some dublicates in the unic key. That sounds self-contradictory. How

RE: insert and deletind dublicating

2002-09-19 Thread Savaidis
-Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 7:59 PM To: Savaidis; mysql list Subject: RE: insert and deletind dublicating At 17:54 +0300 9/19/02, Savaidis wrote: I had already done the first (insert ignore into bla-bla ) solution