MySQL schema commands

Select a database:

use {database_name};

Show all tables:

show tables;

Show all columns in a table

describe {table_name};
show columns from {table_name};

Show indices:

show index from {table_name};

Show MySQL status;

show engine innodb status;