Hi John, ----- Original Message ----- From: "John Mistler" Sent: Sunday, May 02, 2004 12:50 AM Subject: Indexing
> I know this is an elementary question, but I am getting two sets of > instructions from different MySQL manuals about setting an index on a prefix > of a column of a table. One says to use: > > KEY indexName (colName(length)) > > and the other says to use > > INDEX indexName (colName(length)) > > Are both all right? Any light shed on indexing columns would be much > appreciated. INDEX is a synonym for KEY... or vice versa. So yes, they're both the same. In fact, you'll see that if you use INDEX, and then use SHOW CREATE TABLE, MySQL will have it specified as KEY. :-) > Thanks, > > John Hope that helps. Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]