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

Posted on 2007-07-22
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
    LVL 17

    Expert Comment

    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.
    LVL 9

    Author Comment

    I have 1000s of can I do that? and how can I be sure to delete the duplicates only

    LVL 17

    Accepted Solution

    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

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
    Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL ( several years ago, it seemed like now was a good time to updat…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now