MySQL CREATE DATABASE Statement

MySQL CREATE DATABASE Statement

The CREATE DATABASE statement in MySQL is used to create a new database. It is one of the first steps when starting a new MySQL project.

🔹 Syntax

• database_name → Name of the database to create

• Database names must be unique on the MySQL server.

• Optional clauses: IF NOT EXISTS and character set/collation.

🔹 Syntax with IF NOT EXISTS

• Prevents an error if the database already exists.

🔹 Syntax with Character Set and Collation

• CHARACTER SET → Sets the default character set for the database.

• COLLATE → Sets the default collation (sorting rules).

🔹 Example 1: Simple Database Creation

• Creates a new database called SchoolDB.

🔹 Example 2: Create Database If Not Exists

• Ensures the command doesn’t fail if SchoolDB already exists.

🔹 Example 3: Create Database with UTF8 Character Set

• Sets database to support Unicode characters.

🔹 Key Points

1. Database names should be descriptive and unique.

2. Use IF NOT EXISTS to avoid errors if the database already exists.

3. Specify CHARACTER SET and COLLATE for multi-language support.

4. After creating a database, use: