Mysql全文索引技术测试语句序列

CREATE TABLE `test`.`IndexTest` (
  `pr` INTEGER UNSIGNED NOT NULL,
  `t1` VARCHAR(45) NOT NULL,
  `t2` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`pr`)
)
ENGINE = MyISAM;

insert into IndexTest(pr, t1, t2) values(1, 'jack yy barclay', 'time date value interesting');
insert into IndexTest(pr, t1, t2) values(2, 'mary yy user', 'here there date');
insert into IndexTest(pr, t1, t2) values(3, 'john jack mary', 'value newyork');

select * from IndexTest where match(t2) against('date' IN BOOLEAN MODE) limit 100;
select * from IndexTest where match(t1,t2) against('jack' IN BOOLEAN MODE) limit 100;
select * from IndexTest where match(t1,t2) against('yy' IN BOOLEAN MODE) limit 100;