Why does the number of unique records in mysql not converge?

Question

css

In phpmyadmin I see the following picture in the indexes of the table (screenshot)

At the same time, there cannot be an equal number of unique elements.
The field code has type varchar(50) utf8_unicode_ci
location_id type int(10)
What could be wrong?

Answer 1

Make the yellow block with position: relative, and make the brown ones its children with position: absolute and then align it as needed.

Answer 2

This is the output of the result of the SHOW INDEXES FROM table query, and for InnoDB it shows the devil knows what (Google will give out a bunch of bugs for different versions of MySQL). It seems that the problem was solved in MySQL 5.7
phpmyadmin in this case simply displays what MySQL gives it.

Answer 3

Judging by your picture, as well as the question, I suspect that the matter may be in PHPMyAdmin, or in those who localized it (translated into Russian).
My advice to you is to throw out PHPMyAdmin, it's great for saving ladies small databases or loading them back in a hosting environment. There are a lot of great programs for MySQL:
1. HeidiSQL
2. MySQL Workbench
3. Navicat
, etc.
take any of them and forget about such problems
PS I suspect that in that column (with the heading "Number of unique elements") it is actually indicated not the number of unique elements, but the approximate number of records in the table, perhaps the result generates which one of these commands: this or this. If you want to get an exact answer to this question (what is the number and where does it come from) - you need to enable MySQL logging of all queries and see what queries are executed when this particular page is opened ... find the right one, etc. But I wouldn't waste my time on such nonsense.