MySQL CREATE,SELECT and DROP DATABASE Tutorial
In this tutorial we will learn how create , drop and select database.
MySQL Create Database
You can create a MySQL database by using MySQL Command Line Client.
MySQL Create Database Syntax
CREATE DATABASE database_name;
MySQL Create Database Example
CREATE DATABASE students;
MySQL SELECT Database
SELECT Database is used in MySQL to select a particular database to work with. This query is used when multiple databases are available with MySQL Server.
MuSQL Select Database Syntax
USE database_name;
MySQL Select Database Example
USE students;
MySQL Drop Database
You can drop/delete/remove a MySQL database with the MySQL Drop command. You should be careful while deleting any database because you will lose your all the data available in your database.
MySQL Drop Database Syntax
DROP DATABASE database_name;
MySQL Drop Database Example
DROP DATABASE students;