101 SQL CREATE DATABASE

The current W3Schools page explains the SQL CREATE DATABASE statement.

• The CREATE DATABASE statement in SQL is used to create a new database.
• Syntax:

  CREATE DATABASE databasename;
  

• Example: To create a database named "testDB":

  CREATE DATABASE testDB;
  

• Tip: You need admin privilege to create a database. After creation, you can verify its existence by running SHOW DATABASES;.
• The page includes an exercise question: What is the purpose of the SQL CREATE DATABASE statement? (The answer is: To create a new SQL database).[1]

1

The SQL CREATE DATABASE Statement

The CREATE DATABASE statement is used to create a new SQL database.

Syntax

CREATE DATABASE databasename;

CREATE DATABASE Example

The following SQL statement creates a database called "testDB":

CREATE DATABASE testDB;