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