----- Original Message ----- From: "Benjamin Pflugmann" <[EMAIL PROTECTED]> To: "Mark" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 1:24 AM Subject: Re: Alter table
> 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. Well, the FAQ is where I went first, of course. And then I came up with this, "ALTER ignore table $table MODIFY message_id varchar(255) \ not null secondary key" But MySQL said I had an error in my syntax. :( If I use the ADD INDEX() syntax, will that cause the message_id field to be indexed, also for new message-ids? Thanks. P.S. Yes, I know, I should have considered this when creating the table, that I might also want an index on message-id; but I can no longer drop the current table. - Mark --------------------------------------------------------------------- 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