Debian Codegraph @

mysql-test/suite/innodb_fts/include/tablespace_location.inc

raw
1
2 --eval CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)) TABLESPACE=$TABLESPACE ROW_FORMAT=$ROW_FORMAT $EXTRA_PARAMS
3 --source suite/innodb/include/show_i_s_tables.inc
4
5 INSERT INTO t1 (a,b) VALUES
6 ('MySQL Tutorial','DBMS stands for DataBase') ,
7 ('How To Use MySQL Well','After you went through a'),
8 ('Optimizing MySQL','In this tutorial we will show');
9
10 INSERT INTO t1 (a,b) VALUES
11 ('1001 MySQL Tricks','1. Never run mysqld as root'),
12 ('MySQL vs. YourSQL','In the following database comparison'),
13 ('MySQL Security','When configured properly, MySQL');
14
15 SELECT * FROM t1 WHERE MATCH (a,b)
16 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
17
18 TRUNCATE TABLE t1;
19 --source suite/innodb/include/show_i_s_tables.inc
20
21 INSERT INTO t1 (a,b) VALUES
22 ('MySQL Tutorial','DBMS stands for DataBase') ,
23 ('How To Use MySQL Well','After you went through a'),
24 ('Optimizing MySQL','In this tutorial we will show');
25
26 INSERT INTO t1 (a,b) VALUES
27 ('1001 MySQL Tricks','1. Never run mysqld as root'),
28 ('MySQL vs. YourSQL','In the following database comparison'),
29 ('MySQL Security','When configured properly, MySQL');
30
31 SELECT * FROM t1 WHERE MATCH (a,b)
32 AGAINST ('Tutorial' IN NATURAL LANGUAGE MODE);
33
34 DROP TABLE t1;