MySQL CREATE DB

The MySQL CREATE DATABASE Statement

The CREATE DATABASE statement is employed to initiate the creation of a new SQL database.

Syntax

CREATE DATABASE databasename;

CREATE DATABASE Example

The SQL statement below creates a database named ‘testDB

Example

CREATE DATABASE testDB;

Tip: Ensure you have administrative privileges before creating a database. Once created, you can verify its existence in the list of databases using the SQL command: SHOW DATABASES;