In focus

How To Create Database In MySQL

In this article you will learn how to create and use database in MySQL.

Anmol Garg Apr 12, 2016

MySQL is a Relational Database Management System (RDBMS) that runs as a server which provides multi-user access to a number of databases. It is an open source database software based on the SQL vocabulary,  which can be used in combination with most server-side languages, but it is most commonly employed with PHP.

Creating a Database in MySQL

Create database command is used to create database in MySQL.

Syntax: CREATE Database DATABASE NAME;

Example
: Create database emp;  

(Here we are creating a database with name emp).



Database is created.

To Show Databases in MySQL

Show databases command is use to show databases in MySQL.

Syntax : SHOW DATABASES;

Example: Show databases;

(Here it will display list of databases).



Use Database in MySQL

Use Database command is used to move to a database in MySQL.

Syntax : USE DATABASE NAME;

Example : use EMP;

(In this case the database is changed to EMP).

database mysql 5.7

COMMENT USING