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

RE: insert and deletind dublicating

2002-09-19 Thread Paul DuBois
only for SELECT? > > > >thanks anyway... > > > >Makis > > >-----Original Message- >From: Paul DuBois [mailto:[EMAIL PROTECTED]] >Sent: Thursday, September 19, 2002 5:10 PM >To: Savaidis; mysql list >Subject: Re: insert and deletind dublicating > > &

RE: insert and deletind dublicating

2002-09-19 Thread Savaidis
Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursday, 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&#x

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

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

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