Well, I wanted to limit the size of the index so it wouldn't take up a
lot of space. The message table is about 500mb right now and is going to
get a lot bigger. Well not limiting the size of the index get rid of the
error?
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 3/26/01, 11:35:19 AM, "LIBASOV IOANNIS" <[EMAIL PROTECTED]> wrote regarding
Re: alter table error:
> It's better like this:
> alter table message add index subject2 (subject);
> ----- Original Message -----
> From: "Daniel Adams" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, March 26, 2001 7:19 PM
> Subject: alter table error
> Can anyone tell me what this means and how to fix it? I ran the below
> query to simple add another index and this is what i got. Thank you.
> mysql> alter table message add index subject2 (subject(10));
> ERROR 1034: 126 for record at pos 176850808
> - Dan
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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