Link to home
Start Free TrialLog in
Avatar of syedasimmeesaq
syedasimmeesaqFlag for United States of America

asked on

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

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?
Avatar of Jason Minton
Jason Minton
Flag of United States of America image

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.
Avatar of syedasimmeesaq

ASKER

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

thanks
ASKER CERTIFIED SOLUTION
Avatar of Jason Minton
Jason Minton
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial