Back to MySQL Notes
Topic #47

MySQL Create DB


The MySQL CREATE DATABASE Statement

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

Tip: You need administrative privileges to create a new database.

Syntax

CREATE DATABASE database_name;

CREATE DATABASE Example

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

Example

CREATE DATABASE testDB;

Show Databases

Once a database is created, you can check it in the list of databases with the following SQL command:

Syntax

SHOW DATABASES;

Want to go beyond the notes?

Join Coding Now Tech Institute's MySQL course — live mentorship, real projects, and 100% placement support.

Enroll Now — Free Demo Available

MySQL Create DB – FAQs

Quick answers about learning MySQL Create DB in MySQL.

This free note from Coding Now Tech Institute explains MySQL Create DB in MySQL — concept, syntax and worked code examples you can copy, run and revise before interviews.
Yes. Every MySQL topic on Coding Now Tech Institute, including MySQL Create DB, is 100% free with no signup required.
With focused practice, most students grasp MySQL Create DB in 1–3 days from these notes; pairing it with Coding Now Tech Institute's mentor-led course takes you to job-ready depth faster.
Use the code examples in this note, then ask doubts for free on the Coding Now Tech Institute Community (/community) — expert instructors answer within 24 hours.
Call NowEnroll Now