Skip to content

Instantly share code, notes, and snippets.

@aa21

aa21/MySql - Index all columns

Last active August 29, 2015 14:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aa21/50425fd7423c385f5a02 to your computer and use it in GitHub Desktop.
Save aa21/50425fd7423c385f5a02 to your computer and use it in GitHub Desktop.
Download ZIP
Bruteforce. Index all the columns in all tables of a db.
Raw
MySql - Index all columns
-- Bruteforce. Index all the columns in all tables of a db.
-- Find the data types
-- select distinct data_type from information_schema.columns where table_schema="DATABASE";
select
concat( "ALTER TABLE `DATABASE`.`", table_name , "` ADD INDEX ( `",column_name ,"` );" )
from information_schema.columns where table_schema='DATABASE' and
data_type not in ('text', 'longtext', 'mediumtext','tinytext' );
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment