0
votes
1answer
159 views

In MySQL 5.1 InnoDB, does the maximum length of a VARCHAR affect secondary index size? [closed]

Assuming the data is the same either way, does the maximum length of the VARCHAR affect the space usage of a secondary index? Does InnoDB use fixed length records for indexes? Assume that we're ...
0
votes
1answer
224 views

Mysql : Cannot create Index:

Hi all we are having trouble to create/drop index(s) on a table I keep getting the following error: ERROR 1280 (42000): Incorrect index name '<>' Now the table has the following: 1. PRIMARY ...