CIS 340 – Database Systems – LAB Works – SQL Commands – Dr. Asim Elshiekh
Page 1 of 3
Database Systems – LAB Works
Structured Query Language (SQL) Commands
(1) Database Level Commands:
#
SQL Command
Description
Syntax
1
Create Database
To create a new database in MySQL.
Create Database DatabaseName;
2
Show Databases
To show all databases that are exist in MySQL.
Show Databases;
3
Connect
To connect to a database in MySQL.
Connect DatabaseName;
4
Use
To use and work on a database in MySQL.
Use DatabaseName;
5
Show Tables
To show all tables that are exist in a database.
Show Tables;
6
Drop Database
To remove an existing database from MySQL.
Drop Database DatabaseName;
