Breaking News
Loading...
22/12/2013

MySQL: Detect duplicate keys using common_schema framework

Detect duplicate keys:
SELECT redundant_index_name, sql_drop_index FROM redundant_keys;
+----------------------+----------------------------------------------------------+
| redundant_index_name | sql_drop_index                                           |
+----------------------+----------------------------------------------------------+
| rental_date_2        | ALTER TABLE `sakila`.`rental` DROP INDEX `rental_date_2` |
+----------------------+----------------------------------------------------------+
http://common-schema.googlecode.com/svn/trunk/common_schema/doc/html/redundant_keys.html

0 comments:

Post a Comment

 
Toggle Footer