mysql> use armycounter
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> describe isles;
+------------+-----------------------+------+-----+---------+----------------+
| Field      | Type                  | Null | Key | Default | Extra          |
+------------+-----------------------+------+-----+---------+----------------+
| isleid     | mediumint(8) unsigned |      | PRI | NULL    | auto_increment |
| pos1       | tinyint(3) unsigned   |      |     | 0       |                |
| pos2       | tinyint(3) unsigned   |      |     | 0       |                |
| pos3       | tinyint(3) unsigned   |      |     | 0       |                |
| ruler_name | varchar(32)           | YES  |     | NULL    |                |
| name       | varchar(255)          |      |     | unnamed |                |
| gold       | varchar(255)          |      |     | 1000    |                |
| stone      | varchar(255)          |      |     | 1000    |                |
| lumber     | varchar(255)          |      |     | 1000    |                |
| mh         | tinyint(2) unsigned   |      |     | 1       |                |
| gm         | tinyint(2) unsigned   |      |     | 0       |                |
| sm         | tinyint(2) unsigned   |      |     | 0       |                |
| lm         | tinyint(2) unsigned   |      |     | 0       |                |
| lab        | tinyint(2) unsigned   |      |     | 0       |                |
| har        | tinyint(2) unsigned   |      |     | 0       |                |
| bar        | tinyint(2) unsigned   |      |     | 0       |                |
| sh         | tinyint(2) unsigned   |      |     | 0       |                |
| sw         | tinyint(2) unsigned   |      |     | 0       |                |
| wt         | tinyint(2) unsigned   |      |     | 0       |                |
| stt        | mediumint(8) unsigned |      |     | 0       |                |
| sp         | mediumint(8) unsigned |      |     | 0       |                |
| arc        | mediumint(8) unsigned |      |     | 0       |                |
| cat        | mediumint(8) unsigned |      |     | 0       |                |
| lws        | mediumint(8) unsigned |      |     | 0       |                |
| sws        | mediumint(8) unsigned |      |     | 0       |                |
| lms        | mediumint(8) unsigned |      |     | 0       |                |
| sms        | mediumint(8) unsigned |      |     | 0       |                |
| coly       | mediumint(8) unsigned |      |     | 0       |                |
+------------+-----------------------+------+-----+---------+----------------+
28 rows in set (0.03 sec)

mysql>
mysql> select * from isles where ruler_name="pureone" LIMIT 5;
+--------+------+------+------+------------+------------+------+-------+--------+----+----+----+----+-----+-----+-----+----+----+----+-----+-----+-----+-----+-----+-----+-----+-----+------+
| isleid | pos1 | pos2 | pos3 | ruler_name | name       | gold | stone | lumber | mh | gm | sm | lm | lab | har | bar | sh | sw | wt | stt | sp  | arc | cat | lws | sws | lms | sms | coly |
+--------+------+------+------+------------+------------+------+-------+--------+----+----+----+----+-----+-----+-----+----+----+----+-----+-----+-----+-----+-----+-----+-----+-----+------+
|  13248 |   42 |   12 |   15 | pureone    |  |42|12|15 | 1000 | 1000  | 1000   |  1 |  0 |  0 |  0 |   0 |   0 |   0 |  0 |  0 |  0 |   0 | 250 |   0 |   0 |  43 |   0 |   0 |   0 |    1 |
|  13247 |   42 |    1 |    7 | pureone    |  |42|01|07 | 1000 | 1000  | 1000   |  1 |  0 |  0 |  0 |   0 |   0 |   0 |  0 |  0 |  0 |   0 | 573 |   0 |   0 | 246 |   0 |   0 |   0 |    1 |
|  13246 |   41 |   36 |   22 | pureone    |  |41|36|22 | 1000 | 1000  | 1000   |  1 |  0 |  0 |  0 |   0 |   0 |   0 |  0 |  0 |  0 |   0 | 241 |   0 |   4 |  33 |   0 |   0 |   0 |    1 |
|  13245 |   41 |   10 |    8 | pureone    |  |41|10|08 | 1000 | 1000  | 1000   |  1 |  0 |  0 |  0 |   0 |   0 |   0 |  0 |  0 |  0 |   0 | 250 |   0 |   0 |  66 |   0 |   0 |   0 |    0 |
|  13244 |   32 |   72 |   18 | pureone    |  |32|72|18 | 1000 | 1000  | 1000   |  1 |  0 |  0 |  0 |   0 |   0 |   0 |  0 |  0 |  0 |   0 | 500 |   0 |   4 |  56 |   0 |   0 |   0 |    1 |
+--------+------+------+------+------------+------------+------+-------+--------+----+----+----+----+-----+-----+-----+----+----+----+-----+-----+-----+-----+-----+-----+-----+-----+------+
5 rows in set (0.04 sec)