MariaDB [test]> CREATE TABLE `revision_actor_temp` ( -> `revactor_rev` int(10) unsigned, -> `revactor_actor` bigint(20) unsigned DEFAULT NULL, -> `revactor_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0', -> `revactor_page` int(10) unsigned NOT NULL -> ); Query OK, 0 rows affected (0.016 sec) MariaDB [test]> select TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,COLUMN_DEFAULT,IS_NULLABLE,DATA_TYPE from information_schema.columns where TABLE_NAME='revision_actor_temp'; +--------------+---------------------+--------------------+--------------------------------+-------------+-----------+ | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | COLUMN_DEFAULT | IS_NULLABLE | DATA_TYPE | +--------------+---------------------+--------------------+--------------------------------+-------------+-----------+ | test | revision_actor_temp | revactor_rev | NULL | YES | int | | test | revision_actor_temp | revactor_actor | NULL | YES | bigint | | test | revision_actor_temp | revactor_timestamp | '\0\0\0\0\0\0\0\0\0\0\0\0\0\0' | NO | binary | | test | revision_actor_temp | revactor_page | NULL | NO | int | +--------------+---------------------+--------------------+--------------------------------+-------------+-----------+ 4 rows in set (0.003 sec)