ちょこちょこ使うi_s関連のSELECTステートメント。 やる前にSET GLOBAL innodb_stats_on_metadata= 0; しておかないと重くなる。 mysql56> SELECT CONCAT(table_schema, '.', table_name) AS object, column_type FROM columns WHERE column_name= ? ORDER BY 1, 2; mysql56> SELECT CONCAT(table_schema, '.', table_name) AS object, index_name, GROUP_CONCAT(column_name ORDER BY seq_in_index) AS columns FROM statistics WHERE table_schema NOT IN ('mysql',