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