Database Information

(2019-02-28)

List tables in a database

SHOW TABLES

List columns in a table

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