Monthly Archives: October 2013

MySQL: Bulk Remove Redundant Index

Find the [TARGET_DATABSE] and replace it with the target database Execute the query Copy the result and execute each of the SQL statement to remove the index

MySQL: Bulk PK Rename

Copy & Paste the result in your MySQL editor and execute the SQL. References http://stackoverflow.com/questions/7691816/group-concat-comma-separator-mysql http://stackoverflow.com/questions/893874/mysql-determine-tables-primary-key-dynamically/893922#893922 http://mysql-0v34c10ck.blogspot.com/2011/05/better-way-to-get-primary-key-columns.html