Re: Duplicate of Everything in Table

2001-04-06 Thread oltra jean-michel
On Fri, 6 Apr 2001, Vigile wrote: > Date: Fri, 6 Apr 2001 01:26:05 -0400 > From: Vigile <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Duplicate of Everything in Table > > I have a table, that DOES NOT have a primary key, but is setup like this: > >

Re: Duplicate of Everything in Table

2001-04-06 Thread Thalis A. Kalfigopoulos
lds I can't do that. > > > > > > > > Ryan Shrout > > > > Production Manager > > > > Athlonmb.com > > > > http://www.athlonmb.com > > > > [EMAIL PROTECTED] > > > > > > > > - Original Message - > &

Re: Duplicate of Everything in Table

2001-04-06 Thread Gerald Clark
er > > > Athlonmb.com > > > http://www.athlonmb.com > > > [EMAIL PROTECTED] > > > > > > - Original Message - > > > From: "Gerald Clark" <[EMAIL PROTECTED]> > > > To: "Vigile" <[EMAIL PROTECTED]> > >

Re: Duplicate of Everything in Table

2001-04-06 Thread Thalis A. Kalfigopoulos
thlonmb.com > > http://www.athlonmb.com > > [EMAIL PROTECTED] > > > > - Original Message - > > From: "Gerald Clark" <[EMAIL PROTECTED]> > > To: "Vigile" <[EMAIL PROTECTED]&

Re: Duplicate of Everything in Table

2001-04-06 Thread Gerald Clark
> To: "Vigile" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Friday, April 06, 2001 9:54 AM > Subject: Re: Duplicate of Everything in Table > > > Sorry: > > ALTER IGNORE TABLE Pages ADD UNIQUE ( PageID, ArticleID, PageTitle, Text >

Re: Duplicate of Everything in Table

2001-04-06 Thread Vigile
duction Manager Athlonmb.com http://www.athlonmb.com [EMAIL PROTECTED] - Original Message - From: "Gerald Clark" <[EMAIL PROTECTED]> To: "Vigile" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, April 06, 2001 9:54 AM Subject: Re: Duplicate of Everythi

Re: Duplicate of Everything in Table

2001-04-06 Thread Gerald Clark
PROTECTED]> > To: "Vigile" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Friday, April 06, 2001 9:34 AM > Subject: Re: Duplicate of Everything in Table > > > Do an: > > alter ignore table add unique ( firstcol, nextcol, ... lastcol ) > >

Re: Duplicate of Everything in Table

2001-04-06 Thread Vigile
hlonmb.com http://www.athlonmb.com [EMAIL PROTECTED] - Original Message - From: "Gerald Clark" <[EMAIL PROTECTED]> To: "Vigile" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, April 06, 2001 9:34 AM Subject: Re: Duplicate of Everything in Table

Re: Duplicate of Everything in Table

2001-04-06 Thread Gerald Clark
; http://www.athlonmb.com > > [EMAIL PROTECTED] > > > > > > - Original Message - > > From: "Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]> > > To: "Vigile" <[EMAIL PROTECTED]> > > Cc: <[EMAIL PROTECTED]> > &g

Duplicate of Everything in Table

2001-04-05 Thread Vigile
> http://www.athlonmb.com > [EMAIL PROTECTED] > > > - Original Message - > From: "Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]> > To: "Vigile" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Friday, April 06, 2001 1:57 AM &

Re: Duplicate of Everything in Table

2001-04-05 Thread Thalis A. Kalfigopoulos
On Fri, 6 Apr 2001, Vigile wrote: > I have a table, that DOES NOT have a primary key, but is setup like this: > > Field Type Attributes Null Default Extra Action > PageID int(11)No 0Change Drop Primary Index Unique > ArticleID int(11)No 0Change Drop Primar

AW: Duplicate of Everything in Table

2001-04-05 Thread Jens Vonderheide
> So, when I am calling info from this database, I get doubles of > each result. How can I delete just one of each entry, so I am > left with just: Use: DELETE FROM WHERE LIMIT 1 Jens - Before posting, please check: htt

Duplicate of Everything in Table

2001-04-05 Thread Vigile
I have a table, that DOES NOT have a primary key, but is setup like this: Field Type Attributes Null Default Extra Action PageID int(11)No 0Change Drop Primary Index Unique ArticleID int(11)No 0Change Drop Primary Index Unique PageTitle textNo