More than one INDEX key was created for column `last_name`

Posted on 2007-07-22
Medium Priority
Last Modified: 2009-12-16
I have a mysql table and I see this warning in phpmyadmin

More than one INDEX key was created for column `last_name`

What is that for?
Question by:syedasimmeesaq
  • 2
LVL 17

Expert Comment

ID: 19544751
You have more than one index... You should remove the duplicates.  If you have phpmyadmin you should be able to see them, click on them and remove them.

Author Comment

ID: 19545230
I have 1000s of records..how can I do that? and how can I be sure to delete the duplicates only

LVL 17

Accepted Solution

jasonsbytes earned 2000 total points
ID: 19546899
ok, if they are actual duplicates, you will see them in the Index section in phpmyadmin when you click on the table name.

You don't have to look at your records.

In the 'indexes' section, look under 'keyname' and look for names that end in _2 or _3, etc.

If you don't see those, then you probably just have indexes with multiple fields where one index is comprised of 2 or more columns and some of those may be using the same column name, and if so, that is FINE, don't worry about it... phpmyadmin will show a warning, but you can ignore it.

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question