1DROP TABLE IF EXISTS diaries; 2CREATE TABLE diaries ( 3id INT PRIMARY KEY AUTO_INCREMENT, 4title TEXT, 5body TEXT, 6FULLTEXT INDEX title_index (title), 7FULLTEXT INDEX body_index (body) 8) ENGINE MyISAM DEFAULT CHARSET UTF8; 9SELECT table_name, engine, table_comment 10FROM information_schema.tables 11WHERE table_name = 'diaries'; 12table_name engine table_comment 13diaries MyISAM 14INSERT INTO diaries (title, body) VALUES ("survey", "will start groonga!"); 15INSERT INTO diaries (title, body) VALUES ("groonga (1)", "starting groonga..."); 16SELECT * FROM diaries 17WHERE MATCH(title) AGAINST("survey" IN BOOLEAN MODE) AND 18MATCH(body) AGAINST("groonga" IN BOOLEAN MODE); 19id title body 201 survey will start groonga! 21ALTER TABLE diaries ENGINE = mroonga COMMENT = 'ENGINE "InnoDB"'; 22SELECT table_name, engine, table_comment 23FROM information_schema.tables 24WHERE table_name = 'diaries'; 25table_name engine table_comment 26diaries Mroonga ENGINE "InnoDB" 27SELECT * FROM diaries 28WHERE MATCH(title) AGAINST("survey" IN BOOLEAN MODE) AND 29MATCH(body) AGAINST("groonga" IN BOOLEAN MODE); 30id title body 311 survey will start groonga! 32INSERT INTO diaries (title, body) VALUES ("groonga (2)", "started groonga."); 33SELECT * FROM diaries 34WHERE MATCH(title) AGAINST("groonga" IN BOOLEAN MODE) AND 35MATCH(body) AGAINST("groonga" IN BOOLEAN MODE); 36id title body 372 groonga (1) starting groonga... 383 groonga (2) started groonga. 39DROP TABLE diaries; 40