Start using MySQL
Navigate databases and tables
Create the notes database with deliberate Unicode defaults, select it for the session, and inspect its tables and schema.
8 minute lesson
~~~
MySQL calls a named collection of tables a database. Create this course database with an explicit character set and collation:
CREATE DATABASE notes_app
CHARACTER SET utf8mb4
COLLATE utf8mb4_0900_ai_ci;
USE notes_app;
SHOW TABLES;Use DESCRIBE notes; to inspect a table. Always confirm the active database before running destructive statements.
Lesson completed