Create Database Command in MySQL

Create Database Command in MySQL

In this article, we will see how to create a database command in MySQL.

To store and process data of a business, a company, an organization, etc.; the first step is to create a database for it.
To create a database in MySQL server; we take the help of creating the database :

Basic Syntax:

create database [ if not exists ] databasename;

Ex:

create database if not exists db_wonderdevelop;

Note:
While creating a database; if you don’t specify if not exists clause & the database you want to create already exists in the server then an error is thrown.

While creating a database; if you don’t know whether the database that you want to create already exists in the server or not then you must specify the if not exists clause.

While creating a database; if you know that the database that you want to create does not already exist in the server then you need not specify not exist clause.

Leave a Reply