18 messages in com.mysql.lists.mysqlRe: Alter table
FromSent OnAttachments
mike markovich15 May 2002 11:47 
Paul DuBois15 May 2002 13:01 
mike markovich15 May 2002 13:53 
Mark Matthews15 May 2002 14:06 
Paul DuBois15 May 2002 14:08 
Gurhan Ozen15 May 2002 14:10 
mike markovich15 May 2002 14:29 
Keith C. Ivey15 May 2002 14:54 
Mark Matthews15 May 2002 15:27 
Mark15 May 2002 15:47 
MikeParton15 May 2002 16:01 
Orr, Steve15 May 2002 16:08 
Benjamin Pflugmann15 May 2002 16:23 
Roger Baklund15 May 2002 16:28 
Mark15 May 2002 16:39 
Mark Matthews15 May 2002 16:45 
Mark15 May 2002 17:34 
Benjamin Pflugmann16 May 2002 09:41 
Subject:Re: Alter table
From:Benjamin Pflugmann (benj@pflugmann.de)
Date:05/15/2002 04:23:41 PM
List:com.mysql.lists.mysql

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, adm@asarian-host.net 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? :(

[...]

-- benj@pflugmann.de