blob: 6e00526c7364d5e7d10bf18cd0c2c0bb3d32c438 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
SET NAMES utf8;
CREATE TABLE memos (
content VARCHAR(64) NOT NULL PRIMARY KEY,
FULLTEXT INDEX (content) FLAGS='WITH_POSITION|WITH_WEIGHT'
) COMMENT='ENGINE "InnoDB"' DEFAULT CHARSET=utf8;
SHOW CREATE TABLE memos;
Table Create Table
memos CREATE TABLE `memos` (
`content` varchar(64) NOT NULL,
PRIMARY KEY (`content`),
FULLTEXT KEY `content` (`content`) `FLAGS`='WITH_POSITION|WITH_WEIGHT'
) ENGINE=Mroonga DEFAULT CHARSET=utf8 COMMENT='ENGINE "InnoDB"'
SELECT mroonga_command("dump --dump_plugins no --dump_schema no");
mroonga_command("dump --dump_plugins no --dump_schema no")
column_create memos-content index COLUMN_INDEX|WITH_WEIGHT|WITH_POSITION memos
DROP TABLE memos;
|