1DROP TABLE IF EXISTS diaries; 2SET NAMES utf8; 3CREATE TABLE diaries ( 4id int PRIMARY KEY, 5title varchar(255), 6created_at datetime, 7KEY title_and_created_at_index (title, created_at) 8) COMMENT='ENGINE "InnoDB"' DEFAULT CHARSET=utf8; 9INSERT INTO diaries VALUES (1, "Hello", "2012-04-30 20:00:00"); 10INSERT INTO diaries VALUES (2, "天気" , "2012-04-30 23:00:00"); 11INSERT INTO diaries VALUES (3, "富士山", "2012-04-30 19:00:00"); 12SELECT * 13FROM diaries 14FORCE INDEX (title_and_created_at_index) 15WHERE title = "天気" AND 16created_at = "2012-04-30 23:00:00"; 17id title created_at 182 天気 2012-04-30 23:00:00 19ALTER TABLE diaries DISABLE KEYS; 20SELECT * 21FROM diaries 22FORCE INDEX (title_and_created_at_index) 23WHERE title = "天気" AND 24created_at = "2012-04-30 23:00:00"; 25id title created_at 262 天気 2012-04-30 23:00:00 27DROP TABLE diaries; 28