rendered paste bodymysql> 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)