Creating Databases and Tables

Part of the MySQL course

Want to learn MySQL Creating Databases and Tables in a real environment?

Click below, get a fresh Linux box with MySQL ready to go, and work through Creating Databases and Tables hands-on with an AI tutor that knows your code.

Start this lessonCreating Databases and Tables

What you'll learn

CREATE DATABASE
Character sets and collation
CREATE TABLE
PRIMARY KEY
AUTO_INCREMENT
NOT NULL
DEFAULT
DROP TABLE
SHOW CREATE TABLE

Read this lesson in your language

English Español Português العربية فارسی Français हिन्दी 中文 Bahasa Indonesia Русский Deutsch

The mysql CLI and First Commands

Data Types

Academy/Catalog/MySQL/Creating Databases and Tables

IntermediateLesson 3 of 1330 min · hands-on