MYSQL - SHOW Syntax

자주 쓰는 편인것;
13.7.5.5 SHOW COLUMNS Syntax

SHOW [FULL] COLUMNS {FROM | IN} tbl_name [{FROM | IN} db_name]
    [LIKE 'pattern' | WHERE expr]

13.7.5.10 SHOW CREATE TABLE Syntax

SHOW CREATE TABLE tbl_name

13.7.5.38 SHOW VARIABLES Syntax

SHOW [GLOBAL | SESSION] VARIABLES
    [LIKE 'pattern' | WHERE expr]

http://dev.mysql.com/doc/refman/5.7/en/show.html