1drop table if exists t1; 2CREATE TABLE t1 ( 3kodoboru varchar(10) default NULL, 4obor tinytext, 5aobor tinytext, 6UNIQUE INDEX kodoboru (kodoboru), 7FULLTEXT KEY obor (obor), 8FULLTEXT KEY aobor (aobor) 9); 10INSERT INTO t1 VALUES ('0101000000','aaa','AAA'); 11INSERT INTO t1 VALUES ('0102000000','bbb','BBB'); 12INSERT INTO t1 VALUES ('0103000000','ccc','CCC'); 13INSERT INTO t1 VALUES ('0104000000','xxx','XXX'); 14select * from t1; 15kodoboru obor aobor 160101000000 aaa AAA 170102000000 bbb BBB 180103000000 ccc CCC 190104000000 xxx XXX 20drop table t1; 21