MySQL Non-unique Indexes

(Michael McLaughlin) Somebody wanted to know how to find any non-unique indexes in information_schema of the MySQL. The query takes a session variable with the table name and returns the non-unique indexes by column names. It uses a correlated subquery to exclude the table constraints.

Read More - Register for Free Membership