blob: c09ec340ccbe87e308fba47f5869ab4780a3d39e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
DROP TABLE IF EXISTS diaries;
FLUSH STATUS;
CREATE TABLE diaries (
title TEXT,
FULLTEXT INDEX ft(title)
);
INSERT INTO diaries VALUES("Hello mroonga!");
INSERT INTO diaries VALUES("It's funny.");
INSERT INTO diaries VALUES("Happy birthday!");
SHOW STATUS LIKE 'mroonga_count_skip';
Variable_name Value
Mroonga_count_skip 0
SELECT COUNT(*) FROM diaries WHERE MATCH(title) AGAINST("mroonga" IN BOOLEAN MODE);
COUNT(*)
1
SHOW STATUS LIKE 'mroonga_count_skip';
Variable_name Value
Mroonga_count_skip 1
DROP TABLE diaries;
|
