IntermediateLesson 4 of 1330 min 路 hands-on
Data Types
Part of the MySQL course
Look back at the products table from the last lesson and you will notice every column had a type: INT, VARCHAR(120), DECIMAL(10, 2). Those were not decoration. The type you pick for a column decides what MySQL will accept, how much space it takes on disk, how it sorts, and sometimes whether your numbers are even correct.
Open the terminal, connect as root (the password is easyenv, as in lesson 02), and give this lesson a fresh database of its own ...
Want to learn MySQL Data Types in a real environment?
Click below, get a fresh Linux box with MySQL ready to go, and work through Data Types hands-on with an AI tutor that knows your code.
Start this lessonData TypesWhat you'll learn
- INT and BIGINT
- DECIMAL vs FLOAT
- VARCHAR vs TEXT
- BOOLEAN as TINYINT
- DATE vs DATETIME vs TIMESTAMP
- ENUM
- JSON column
Read this lesson in your language
All lessons in this course
13 lessons- 1What is MySQL20 min
- 2The mysql CLI and First Commands25 min
- 3Creating Databases and Tables30 min
- 4Data Types30 min
- 5SELECT and WHERE30 min
- 6Joins35 min
- 7Aggregates and Grouping30 min
- 8Indexes30 min
- 9Transactions and Storage Engines35 min
- 10Stored Procedures and Triggers35 min
- 11EXPLAIN and Query Tuning35 min
- 12mysqldump and Restore25 min
- 13Capstone: Design an Ecommerce Schema50 min
Explore other courses
Python
19 lessons 路 9.3h
Go
20 lessons 路 12.3h
React
17 lessons 路 10.2h
Linux
17 lessons 路 8.5h
Docker
13 lessons 路 6.6h
Git
13 lessons 路 5.9h
Kubernetes
14 lessons 路 8h
Ansible
12 lessons 路 6.1h
Bash
12 lessons 路 5.7h
Helm
10 lessons 路 5.4h
GitLab CI
11 lessons 路 5.8h
Jenkins
11 lessons 路 5.3h
PostgreSQL
14 lessons 路 7.6h
Web
14 lessons 路 5.9h
TypeScript
18 lessons 路 7.7h
Vibe Coding
12 lessons 路 5.8h
Prompt Engineering
11 lessons 路 6.2h
Vibe Coding: Fundamentals
12 lessons 路 4.5h
Vibe Coding: Prototype to Production
12 lessons 路 5.5h
Vibe Coding: Multi-Agent Engineering
12 lessons 路 5.3h
Vibe Coding: Advanced Engineering
12 lessons 路 7.3h