Summary - Data types

Combine columns of different types in one table.

In this group you learned integer, decimal, text, date and boolean types. Choosing the right type matters for storage and accuracy.

CREATE TABLE products (
  id INT,
  price DECIMAL(10,2),
  name VARCHAR(100),
  in_stock BOOLEAN
);

Each column gets the right type.

The table products is created.

Exercise Summary - Data types

Create products with id INT, price DECIMAL(10,2), name VARCHAR(100).

Show example solution

CREATE TABLE products (
  id INT,
  price DECIMAL(10, 2),
  name VARCHAR(100)
)