Debian Codegraph @

mysql-test/suite/innodb_fts/t/zip.test

raw
1 # FTS aux tables inherit row format and key block size
2 # from its parent table.
3
4 CREATE TABLE articles (
5 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
6 title VARCHAR(200),
7 body TEXT,
8 FULLTEXT (title, body)
9 ) ENGINE=InnoDB ROW_FORMAT=compressed KEY_BLOCK_SIZE=2;
10
11 INSERT INTO articles (title, body) VALUES
12 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
13
14 SELECT title, body FROM articles WHERE
15 MATCH(title, body) AGAINST('mysql');
16
17 --source include/restart_mysqld.inc
18
19 INSERT INTO articles (title, body) VALUES
20 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
21
22 SELECT title, body FROM articles WHERE
23 MATCH(title, body) AGAINST('mysql');
24
25 DROP TABLE articles;