Skip to content

Basic Database operations

SHOW

To show all the databases

SHOW DATABASES
CREATE

To create a new database

CREATE DATABASE DB_Name
DROP

To drop or delete databse

DROP DATABASE DB_Name
USE

Getting into a specific database or using perticular database

USE DB_Name
SELECT

To show which database we are currently using

SELECT DATABASE()