show column definition

mysql> SELECT column_name, data_type, character_maximum_length, column_comment FROM information_schema.columns WHERE table_name = 'TABLE_NAME';

mysql> SHOW FULL COLUMNS FROM tableName;