Mostly Used SQL Commands ( important SQL Commands or Queries mostly used)

 

Create a database on the sql server.

    mysql> create database [databasename];

 

List all databases on the sql server.

    mysql> show databases;

 

Switch to a database.

    mysql> use [db name];

 

To delete a db.

    mysql> drop database [database name];

 

To see all the tables in the db.

    mysql> show tables;

To create a table.

    mysql> create  table [table name];

To delete a table.

    mysql> drop table [table name];

To see database's field formats.

    mysql> describe [table name];

Show all data in a table.

    mysql> SELECT * FROM [table name];