mysql> describe tree;
+-----------+-----------+------+-----+---------+-------+
| Field     | Type      | Null | Key | Default | Extra |
+-----------+-----------+------+-----+---------+-------+
| code      | char(8)   | NO   | PRI | NULL    |       |
| sorder    | char(128) | YES  |     | NULL    |       |
| country   | char(20)  | NO   | MUL |         |       |
| state     | char(20)  | NO   | MUL |         |       |
| name      | char(64)  | NO   | MUL |         |       |
| tax       | text      | YES  |     | NULL    |       |
| postcode  | char(20)  | NO   | MUL |         |       |
| shipmodes | char(128) | YES  |     | NULL    |       |
| tax_name  | char(128) | YES  |     | NULL    |       |
+-----------+-----------+------+-----+---------+-------+
9 rows in set (0.13 sec)