Guided Notes

Creating Databases & Tables

CREATE and DROP DATABASE, CREATE TABLE with MySQL data types, ALTER TABLE, DROP and TRUNCATE, and choosing the right types.

Databases

Slide 1 / 5

A MySQL server hosts many databases (also called schemas):

CREATE DATABASE shop; CREATE DATABASE IF NOT EXISTS shop; SHOW DATABASES; USE shop; -- make it the current database DROP DATABASE shop; -- deletes it and every table inside — permanently

Set a character set for full Unicode (including emoji): CREATE DATABASE shop CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

← CASE, NULL Functions & Operators