Summary - CREATE TABLE

Combine column types, NOT NULL and PRIMARY KEY to build a table.

In this group you learned CREATE TABLE, PRIMARY KEY, NOT NULL, DEFAULT and AUTO_INCREMENT. Creating tables is now easy.

CREATE TABLE products (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  stock INT DEFAULT 0
);

This query creates a fully-featured products table.

The table products is created.

Exercise Summary - CREATE TABLE

Create products with id INT PRIMARY KEY, name VARCHAR(100) NOT NULL.

Show example solution

CREATE TABLE products (
  id INT PRIMARY KEY,
  name VARCHAR(100) NOT NULL
)