> Do the names of indexes have any significance to MySQL internals > or is the name merely a convenience for the DB operator ? Well, "PRIMARY KEY" does carry some significance... ;-) Other than that, no. But you need them if you should ever want to do an ALTER TABLE to change the index definitions. > For now I try to match the index names to the column names used > but I'm wondering if the name matters at all. They only "matter" as far as using logical names will help you keep your sanity when you need to restructure your DB three years hence. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq --------------------------------------------------------------------- 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
