How to Create Database in MySQL

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).