Hi.
Please start a new thread next time, instead of replying to a
completely unrelated topic. Thank you.
It sounds as if you want
ALTER TABLE your_table ADD INDEX( message_id )
It is probably enough to only index some part of that field and save a
lot of space:
ALTER TABLE your_table ADD INDEX( message_id(15) )
For more information about this, have a look in the manual about ALTER
TABLE and CREATE TABLE.
Regards,
Benjamin.
On Thu, May 16, 2002 at 12:47:26AM +0200, [EMAIL PROTECTED] wrote:
> Can some please help me?
>
> I created a MySQL table with newsgroup articles in them, and indexed them on
> article_num,
[...]
> message_id varchar(255) not null secondary key
>
> Can I alter the table to this effect, or am I too late? :(
>
[...]
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
