Page 91 - PowerPoint Presentation
P. 91
CAVITE STATE UNIVERSITY
T3 CAMPUS
Department of Information Technology DCIT 55 – Advance Database System
Now you are ready to create database.
Syntax: CREATE DATABASE database_name;
Let’s take an example to create a database name ‘christian’. It will look like this.
NOTE: All the database names, table names and table fields names are case sensitive. You
must have to use proper names while giving any SQL command.
MySQL SHOW Database
You can check the created database by following query: SHOW DATABASES;
Here, you can see all the created databases.
MySQL DROP Database
You can drop/delete/remove a MySQL database easily with the MySQL command. You should
be careful deleting any database because you will lose all your data available in your
database.
Syntax: DROP DATABASE database_name;
Let’s take an example to drop a database named ‘christian’.
Page | 7
