Create Database in MySQL

MySQL CREATE DATABASE

To create a MySQL database, open the MySQL Command Line Client. The MySQL Command Line Client will appear with a mysql> prompt. Here you will have to write the already set password. Now the next step is the creation of the database.

Syntax:
CREATE DATABASE name;
Parameters: name: It is used to specify the name of the database to be created. The database name, table name, and table fields’ names in MySQL are case-sensitive.
Example:
CREATE DATABASE students;  
Explanation: A new database will be created with the name ‘students’. To check all the created databases, the below query, should be executed.
Please follow and like us:
Content Protection by DMCA.com