MySQL Common Commands

To view a list of tables that your database contains, from the mysql command prompt type:

show tables;

To view a description of the fields that a table contains, from the mysql command prompt type:

describe <table name>;

For more information on using MySQL: