MariaDB [information_schema]> select * from columns where table_name = 'request' and table_schema = 'production'; ++--------------+------------+--------------++--------------------+-----------------+---------------++ || TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME || CHARACTER_SET_NAME | COLLATION_NAME | COLUMN_TYPE || ++--------------+------------+--------------++--------------------+-----------------+---------------++ || production | request | id || NULL | NULL | int(11) || || production | request | email || utf8 | utf8_general_ci | varchar(512) || || production | request | ip || utf8 | utf8_general_ci | varchar(255) || || production | request | name || utf8 | utf8_general_ci | varchar(512) || || production | request | comment || utf8 | utf8_general_ci | varchar(3000) || || production | request | status || utf8 | utf8_general_ci | varchar(255) || || production | request | date || NULL | NULL | timestamp || || production | request | checksum || utf8 | utf8_general_ci | varchar(256) || || production | request | emailsent || utf8 | utf8_general_ci | varchar(10) || || production | request | emailconfirm || utf8 | utf8_general_ci | varchar(255) || || production | request | reserved || NULL | NULL | int(11) || || production | request | useragent || NULL | NULL | blob || || production | request | forwardedip || utf8 | utf8_general_ci | varchar(255) || ++--------------+------------+--------------++--------------------+-----------------+---------------++ 13 rows in set (0.00 sec)