Examples for business, study, careers, love, and more...
Examples :: MYSQL Examples :: Example of Show Columns Mysql Statement

Example of Show Columns Mysql Statement:

SHOW COLUMNS FROM City;
SHOW COLUMNS FROM mytable FROM mydb;
SHOW COLUMNS FROM mydb.mytable;

Example of Mysql Show Columns


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