Re: Creating a Composite Index

2004-07-18 Thread Wesley Furgiuele
David: I believe you mentioned it in a previous thread, but I forget what kind of field NameMam is. It's important because you might be required to give that key part in your index a length. Also, I'm assuming that this index is on a unique identifier field. If it's not, then just substitute th

Creating a Composite Index

2004-07-18 Thread David Blomstrom
I'm trying to create my first composite index and need some help. The MySQL Manual at http://dev.mysql.com/doc/mysql/en/CREATE_INDEX.html offers these directions: CREATE [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name [index_type] ON tbl_name (index_col_name,...) index_col_name: col_name [(l