Actually you don't have to specify all columns in the UNIQUE index. Just one of them,
and the entire row will be dropped for all redundant copies.
So just do:
ALTER IGNORE TABLE lala ADD UNIQUE (PageID);
I didn't remember the IGNORE thing. Nice idea...
regards,
thalis
On Fri, 6 Apr 2001, Gerald Clark wrote:
> Are you checking the manual and following along, or just plugging in my
> hints?
>
> You have to specify a length for the text fields.
> Your total key length must be less than 256 if I remember correctly.
> Choose values that are long enough to be unique.
> EX:
>
> ALTER IGNORE TABLE Pages ADD UNIQUE ( PageID, ArticleID, PageTitle(25),
> Text(100))
>
> Vigile wrote:
> >
> > That gave me:
> >
> > SQL-query:
> >
> > ALTER IGNORE TABLE Pages ADD UNIQUE ( PageID, ArticleID, PageTitle, Text
> > )
> > MySQL said: BLOB column 'PageTitle' used in key specification without a key
> > length
> >
> > I guess because PageTitle and Text are [text] fields I can't do that.
> >
> > Ryan Shrout
> > Production 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 Everything in Table
> >
> > > Sorry:
> > > ALTER IGNORE TABLE Pages ADD UNIQUE ( PageID, ArticleID, PageTitle, Text
> > > )
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
