1DROP TABLE IF EXISTS users; 2SET NAMES utf8; 3CREATE TABLE users ( 4id int unsigned PRIMARY KEY AUTO_INCREMENT 5) DEFAULT CHARSET=utf8 COMMENT='Engine "InnoDB"'; 6ALTER TABLE users 7ADD COLUMN 名前 text, 8ADD FULLTEXT INDEX (名前); 9INSERT INTO users (名前) VALUES ("やまだ"); 10INSERT INTO users (名前) VALUES ("たなか"); 11INSERT INTO users (名前) VALUES ("すずき"); 12SELECT * FROM users; 13id 名前 141 やまだ 152 たなか 163 すずき 17SELECT * FROM users 18WHERE MATCH (名前) AGAINST ('+たなか' IN BOOLEAN MODE); 19id 名前 202 たなか 21SELECT mroonga_command("dump --dump_plugins no --dump_records no"); 22mroonga_command("dump --dump_plugins no --dump_records no") 23table_create mroonga_operations TABLE_NO_KEY 24column_create mroonga_operations record COLUMN_SCALAR UInt32 25column_create mroonga_operations table COLUMN_SCALAR ShortText 26column_create mroonga_operations type COLUMN_SCALAR ShortText 27 28table_create users TABLE_HASH_KEY ShortText 29 30table_create users#@540d@524d TABLE_PAT_KEY ShortText --default_tokenizer TokenBigram --normalizer NormalizerMySQLGeneralCI 31 32column_create users#@540d@524d index COLUMN_INDEX|WITH_POSITION users 33DROP TABLE users; 34