Hi, I added a composite index to a MyISAM table e.g. ALTER TABLE foo ADD INDEX (column1, column2).
Because I didn't specify a name for the index, SHOW KEYS is showing the Key name to be "column1". Is there a command to change the Key name ? I don't want to drop/recreate the index. Thanks Xanana -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]