EasyEnv
MySQL
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 Types

What 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
  1. 1What is MySQL20 min
  2. 2The mysql CLI and First Commands25 min
  3. 3Creating Databases and Tables30 min
  4. 4Data Types30 min
  5. 5SELECT and WHERE30 min
  6. 6Joins35 min
  7. 7Aggregates and Grouping30 min
  8. 8Indexes30 min
  9. 9Transactions and Storage Engines35 min
  10. 10Stored Procedures and Triggers35 min
  11. 11EXPLAIN and Query Tuning35 min
  12. 12mysqldump and Restore25 min
  13. 13Capstone: Design an Ecommerce Schema50 min

Explore other courses

Data Types - MySQL (English) | Engineering Courses