<

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;  
















© copyright 2017-2022 Completedone pvt ltd.