blob: b185bf269f74793c7569341d8fe67c2c95dd82e4 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
DROP TABLE IF EXISTS diaries;
SET NAMES utf8;
CREATE TABLE diaries (
id int PRIMARY KEY,
title varchar(255)
) COMMENT='ENGINE "InnoDB"' DEFAULT CHARSET=utf8;
INSERT INTO diaries VALUES (1, "Hello");
INSERT INTO diaries VALUES (2, "天気");
INSERT INTO diaries VALUES (3, "富士山");
SELECT *
FROM diaries
WHERE MATCH (title) AGAINST ("富士山");
ERROR HY000: Can't find FULLTEXT index matching the column list
CREATE FULLTEXT INDEX title_index on diaries (title);
SELECT *
FROM diaries
FORCE INDEX (title_index)
WHERE MATCH (title) AGAINST ("富士山");
id title
3 富士山
ALTER TABLE diaries DISABLE KEYS;
SELECT *
FROM diaries
FORCE INDEX (title_index)
WHERE MATCH (title) AGAINST ("富士山");
ERROR HY000: Can't find FULLTEXT index matching the column list
DROP TABLE diaries;
|
