poc

db->MyGuests
db->child_porn

+---------------+--------------+------------+-------------+------------------+-------------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+-------------------+-----------------+------------+-----------------------------+---------------------------------+----------------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | COLUMN_DEFAULT    | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | CHARACTER_SET_NAME | COLLATION_NAME    | COLUMN_TYPE     | COLUMN_KEY | EXTRA                       | PRIVILEGES                      | COLUMN_COMMENT |
+---------------+--------------+------------+-------------+------------------+-------------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+-------------------+-----------------+------------+-----------------------------+---------------------------------+----------------+
| def           | db           | MyGuests   | id          |                1 | NULL              | NO          | int       |                     NULL |                   NULL |                10 |             0 | NULL               | NULL              | int(6) unsigned | PRI        | auto_increment              | select,insert,update,references |                |
| def           | db           | MyGuests   | firstname   |                2 | NULL              | NO          | varchar   |                       30 |                     30 |              NULL |          NULL | latin1             | latin1_swedish_ci | varchar(30)     |            |                             | select,insert,update,references |                |
| def           | db           | MyGuests   | lastname    |                3 | NULL              | NO          | varchar   |                       30 |                     30 |              NULL |          NULL | latin1             | latin1_swedish_ci | varchar(30)     |            |                             | select,insert,update,references |                |
| def           | db           | MyGuests   | email       |                4 | NULL              | YES         | varchar   |                       50 |                     50 |              NULL |          NULL | latin1             | latin1_swedish_ci | varchar(50)     |            |                             | select,insert,update,references |                |
| def           | db           | MyGuests   | reg_date    |                5 | CURRENT_TIMESTAMP | NO          | timestamp |                     NULL |                   NULL |              NULL |          NULL | NULL               | NULL              | timestamp       |            | on update CURRENT_TIMESTAMP | select,insert,update,references |                |
+---------------+--------------+------------+-------------+------------------+-------------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+-------------------+-----------------+------------+-----------------------------+---------------------------------+----------------+
5 rows in set (0.09 sec)

hostname=aoeu
version=5.5.43
OS=Ubuntu 14.04.1
backend=ec2-54-72-242-176.eu-west-1.compute.amazonaws.com
pid=/var/run/mysqld/mysqld.pid
version_compile_machine=x86_64
lc_messages_dir=/usr/share/mysql
engine(all except FEDERATED supported)