mysql-columns.sql

SELECT COLUMN_NAME,    DATA_TYPE,    IS_NULLABLE,    COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS limit 10;
+----------------------+-----------+-------------+----------------+
| COLUMN_NAME          | DATA_TYPE | IS_NULLABLE | COLUMN_DEFAULT |
+----------------------+-----------+-------------+----------------+
| CHARACTER_SET_NAME   | varchar   | NO          |                |
| DEFAULT_COLLATE_NAME | varchar   | NO          |                |
| DESCRIPTION          | varchar   | NO          |                |
| MAXLEN               | bigint    | NO          | 0              |
| COLLATION_NAME       | varchar   | NO          |                |
| CHARACTER_SET_NAME   | varchar   | NO          |                |
| ID                   | bigint    | NO          | 0              |
| IS_DEFAULT           | varchar   | NO          |                |
| IS_COMPILED          | varchar   | NO          |                |
| SORTLEN              | bigint    | NO          | 0              |
+----------------------+-----------+-------------+----------------+