Cheat Sheet logoCheat Sheet Today
MySQL DDL and Schema Design Cheatsheet/Create a database

Create a schema if it does not already exist.

Back to sheetBrowse commands
Sign in to save
Section: create and alter tables

Create a database

sql
sql
CREATE DATABASE IF NOT EXISTS app_db CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
Explanation

Using `utf8mb4` is the standard choice for full Unicode support.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing create and alter tables
Create a users table
Create a table with an auto-increment primary key and timestamps.
OpenIn sheetsqlsame section
Add a column
Add a nullable column to an existing table.
OpenIn sheetsqlsame section
Modify a column definition
Change type, size, or nullability.
OpenIn sheetsqlsame section
Rename a column
Rename a column while specifying its full definition.
OpenIn sheetsqlsame section
Drop a column
Remove a column from a table.
OpenIn sheetsqlsame section
Rename a table
Rename a table without recreating it.
OpenIn sheetsqlsame section