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; 9ALTER TABLE diaries DISABLE KEYS; 10INSERT INTO diaries VALUES (1, "Hello", "2012-04-30 20:00:00"); 11INSERT INTO diaries VALUES (2, "天気" , "2012-04-30 23:00:00"); 12INSERT INTO diaries VALUES (3, "富士山", "2012-04-30 19:00:00"); 13SELECT * 14FROM diaries 15FORCE INDEX (title_and_created_at_index) 16WHERE title = "天気" AND 17created_at = "2012-04-30 23:00:00"; 18id title created_at 192 天気 2012-04-30 23:00:00 20ALTER TABLE diaries ENABLE KEYS; 21SELECT * 22FROM diaries 23FORCE INDEX (title_and_created_at_index) 24WHERE title = "天気" AND 25created_at = "2012-04-30 23:00:00"; 26id title created_at 272 天気 2012-04-30 23:00:00 28DROP TABLE diaries; 29