blob: 53ad9b3a37c2ccf4ad1ecd30ac7df0d0e86263cc (
plain)
1
2
3
4
5
6
7
8
9
|
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;
|