Experiment No- 03
AIM: Create, show and drop MYSQL database.
Database: A database is a collection of data that is stored any type of data, including words,
numbers, images, videos, and files. They can be used to store and manage large amount of
data.
Creating a Database: The CREATE DATABASE command is used to create a database.
• Syntax: CREATE DATABASE databaseName;
Showing a Database: The SHOW DATABASES command is used to show all the databases
in the database table.
• Syntax: SHOW DATABASES;
NAME- INDRA BHAN VERMA ROLL NO- 2204220130025
Drop a database: The DROP DATABASE Command is used to drop or delete a database.
• Syntax: DROP DATABASE databaseName;
NAME- INDRA BHAN VERMA ROLL NO- 2204220130025