diff options
| author | unknown <serg@serg.mylan> | 2004-02-04 17:42:18 +0100 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2004-02-04 17:42:18 +0100 |
| commit | c8ff8ec18d96e0482b16a7b40182cfc34fea59db (patch) | |
| tree | c6f1ab5c53996bc5c3f45e0ec465f75af73abce3 /mysql-test/r/fulltext.result | |
| parent | 9d1f86a3a2b19bb6df33475b2fc1712dfe09b744 (diff) | |
| download | mariadb-git-c8ff8ec18d96e0482b16a7b40182cfc34fea59db.tar.gz | |
beautify SHOW INDEX
Diffstat (limited to 'mysql-test/r/fulltext.result')
| -rw-r--r-- | mysql-test/r/fulltext.result | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index e8ae9d3063f..651baad266e 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -5,6 +5,10 @@ INSERT INTO t1 VALUES('MySQL has now support', 'for full-text search'), ('Only MyISAM tables','support collections'), ('Function MATCH ... AGAINST()','is used to do a search'), ('Full-text search in MySQL', 'implements vector space model'); +SHOW INDEX FROM t1; +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment +t1 1 a 1 a A NULL NULL NULL YES FULLTEXT +t1 1 a 2 b A NULL NULL NULL YES FULLTEXT select * from t1 where MATCH(a,b) AGAINST ("collections"); a b Only MyISAM tables support collections @@ -183,7 +187,7 @@ id show keys from t2; Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment t2 1 tig 1 ticket A NULL NULL NULL YES BTREE -t2 1 tix 1 inhalt A NULL 1 NULL YES FULLTEXT +t2 1 tix 1 inhalt A NULL NULL NULL YES FULLTEXT show create table t2; Table Create Table t2 CREATE TABLE `t2` ( |