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
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