1drop table if exists t1, t2, t3; 2create table t1 (c1 int primary key, c2 varchar(100), fulltext index(c2)) default charset utf8 COMMENT = 'engine "innodb"'; 3create table t2 (c1 int primary key, c2 text, fulltext index(c2)) default charset utf8 COMMENT = 'engine "innodb"'; 4insert into t1 values (1, "aa ii uu ee oo"); 5insert into t1 values (2, "ka ki ku ke ko"); 6insert into t1 values (3, "aa ii ii ii oo"); 7insert into t1 values (4, "sa si su se so"); 8insert into t1 values (5, "ta ti ii ii to"); 9insert into t2 values (1, "aa ii uu ee oo"); 10insert into t2 values (2, "ka ki ku ke ko"); 11insert into t2 values (3, "aa ii ii ii oo"); 12insert into t2 values (4, "sa si su se so"); 13insert into t2 values (5, "ta ti ii ii to"); 14select * from t1; 15c1 c2 161 aa ii uu ee oo 172 ka ki ku ke ko 183 aa ii ii ii oo 194 sa si su se so 205 ta ti ii ii to 21select * from t2; 22c1 c2 231 aa ii uu ee oo 242 ka ki ku ke ko 253 aa ii ii ii oo 264 sa si su se so 275 ta ti ii ii to 28select * from t1 where c1=3; 29c1 c2 303 aa ii ii ii oo 31select * from t2 where c1=3; 32c1 c2 333 aa ii ii ii oo 34select * from t1 where c1>3 order by c1 desc; 35c1 c2 365 ta ti ii ii to 374 sa si su se so 38select * from t2 where c1>3 order by c1 asc; 39c1 c2 404 sa si su se so 415 ta ti ii ii to 42select * from t1 where c2>"s" order by c2 desc; 43c1 c2 445 ta ti ii ii to 454 sa si su se so 46select * from t2 where c2>"s" order by c1 asc; 47c1 c2 484 sa si su se so 495 ta ti ii ii to 50select *,match(c2) against("ii") from t1 where match(c2) against("ii") order by match(c2) against("ii") desc; 51c1 c2 match(c2) against("ii") 523 aa ii ii ii oo 524289 535 ta ti ii ii to 349526 541 aa ii uu ee oo 174763 55select *,match(c2) against("ii") from t2 where match(c2) against("ii") order by match(c2) against("ii") asc; 56c1 c2 match(c2) against("ii") 571 aa ii uu ee oo 174763 585 ta ti ii ii to 349526 593 aa ii ii ii oo 524289 60select c1,c2,match(c2) against("ii") from t1 where match(c2) against("ii"); 61c1 c2 match(c2) against("ii") 623 aa ii ii ii oo 524289 635 ta ti ii ii to 349526 641 aa ii uu ee oo 174763 65select c1,c2,match(c2) against("ii") from t1 where match(c2) against("ii"); 66c1 c2 match(c2) against("ii") 673 aa ii ii ii oo 524289 685 ta ti ii ii to 349526 691 aa ii uu ee oo 174763 70drop table t1,t2; 71