Languages

MySQL - index created with CREATE INDEX doesn't show up in Indexes tab (HeidiSQL)

0 points
Asked by:
Dirask Community
6240

Why I can't see index created with CREATE INDEX query in Indexes tab in HeidiSQL?

I've just created full_name_index with the following query:

CREATE INDEX `full_name_index` 
ON `users` (`name`, `surname`);

And it doesn't show up in the Indexes tab in here:

However, I can see the index when I use the following query:

SHOW INDEX FROM `users` FROM `dirask`;

Result of the above query:

MySQL - add index to existing table - result

1 answer
0 points
Answered by:
Dirask Community
6240

The solution was to refresh the database like 5 times using F5 because once didn't work.

MySQL - refresh database in HeidiSQL
MySQL - refresh database in HeidiSQL
0 comments Add comment
Native Advertising
­čÜÇ
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

ÔŁĄ´ŞĆ­čĺ╗ ­čÖé

Join