CodesJava

Easy learning with example program codes

CREATE DATABASE in 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. Write the already set password, and you are ready to create a MySQL 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’ name in MySQL are case sensitive.

Example:

CREATE DATABASE stores;

Explanation:
A new database with the name ‘stores’ will be created in MySQL. All the existing databases can be checked using the below query.
SHOW DATABASES;

Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status