| 1 |
DROP TABLE IF EXISTS t1; |
| 2 |
Warnings: |
| 3 |
Note 1051 Unknown table 'test.t1' |
| 4 |
CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_croatian_ci, KEY(a)) ENGINE=ARIA; |
| 5 |
INSERT INTO t1 VALUES ('na'),('nj'),('nz'),('Z'); |
| 6 |
explain SELECT a FROM t1 ORDER BY a; |
| 7 |
id select_type table type possible_keys key key_len ref rows Extra |
| 8 |
1 SIMPLE t1 index NULL a 33 NULL 4 Using index |
| 9 |
SELECT a FROM t1 ORDER BY a; |
| 10 |
a |
| 11 |
na |
| 12 |
nz |
| 13 |
nj |
| 14 |
Z |
| 15 |
ALTER TABLE t1 engine=myisam; |
| 16 |
explain SELECT a FROM t1 ORDER BY a; |
| 17 |
id select_type table type possible_keys key key_len ref rows Extra |
| 18 |
1 SIMPLE t1 index NULL a 33 NULL 4 Using index |
| 19 |
SELECT a FROM t1 ORDER BY a; |
| 20 |
a |
| 21 |
na |
| 22 |
nz |
| 23 |
nj |
| 24 |
Z |
| 25 |
drop table t1; |