Debian Codegraph @

mysql-test/suite/innodb_fts/r/zip.result

raw
1 CREATE TABLE articles (
2 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
3 title VARCHAR(200),
4 body TEXT,
5 FULLTEXT (title, body)
6 ) ENGINE=InnoDB ROW_FORMAT=compressed KEY_BLOCK_SIZE=2;
7 INSERT INTO articles (title, body) VALUES
8 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
9 SELECT title, body FROM articles WHERE
10 MATCH(title, body) AGAINST('mysql');
11 title body
12 MySQL Tutorial DBMS stands for MySQL DataBase ...
13 # restart
14 INSERT INTO articles (title, body) VALUES
15 ('MySQL Tutorial','DBMS stands for MySQL DataBase ...');
16 SELECT title, body FROM articles WHERE
17 MATCH(title, body) AGAINST('mysql');
18 title body
19 MySQL Tutorial DBMS stands for MySQL DataBase ...
20 MySQL Tutorial DBMS stands for MySQL DataBase ...
21 DROP TABLE articles;