mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 10:56:12 +01:00
9 lines
265 B
Text
9 lines
265 B
Text
CREATE TABLE t1 (a VARCHAR(7), b text, FULLTEXT KEY idx (a,b)) ENGINE=InnoDB;
|
|
COMMIT;
|
|
SELECT COUNT(*) FROM t1
|
|
WHERE MATCH (a,b) AGAINST ('foo bar' IN BOOLEAN MODE);
|
|
connect con1,localhost,root,,;
|
|
KILL QUERY @id;
|
|
disconnect con1;
|
|
connection default;
|
|
DROP TABLE t1;
|