Table Info in MySQL

To see the collation of the database

SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME
FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = '데이타베이스명';

To see the info about a table

SHOW TABLE STATUS where name like '테이블명'\G

To see the info about the columns

SHOW FULL COLUMNS FROM 테이블명;