Creating a Database in SQL

Creating a Database in SQL — a practical guide to SQL CREATE DATABASE with clear examples you can reuse in real projects.

SQL Tutorial Series (13/100). Prefer one article? Read the complete SQL tutorial.

Short description

Pick charset/collation carefully (utf8mb4 is typical for modern apps).

Create DB

CREATE DATABASE shop
  CHARACTER SET utf8mb4
  COLLATE utf8mb4_unicode_ci;
USE shop;