Build a composite index name and age now, for example, they are stored in a string together? Or like table into two columns are stored?

CodePudding user response:

Even by a string attached storage, the string must be at least have a delimiter separated, or query is how to match the first field,
And composite index field is not necessarily the character of
Speculation is divided into multiple columns are stored

CodePudding user response:

First of all, for innodb tables and indexes, the data is in the primary key index of

Second, data stored in files and documents can also check you, of course is together, such as varchar (200), stored in the aaa and aaa is recorded said three characters add a length of 3, will not be checked for it to get a 200