MySQL - Basic command for support

This is a list of MySQL commands that I use time and time again.

1. to login

mysql -u root -p
  

2. to list all databases

mysql> show databases;
   

3. switch to a databases

mysql> use [db name];

      
4. to see all table in database

mysql> show tables;

    

5. to see database's field formats

mysql> describe [table name];