NOT NULL

Mark required columns with NOT NULL.

With NOT NULL you mark a column as required. It is used for mandatory fields.

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

Name cannot be null.

The table products is created.

NOT NULL — details

NOT NULL prevents inserting NULL into a column. It matters for data integrity; critical fields should always be NOT NULL.

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

Show example solution

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

Required field

CREATE TABLE products (
  id INT PRIMARY KEY,
  name VARCHAR(100) ____
);

Show answer

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

Next lesson: DEFAULT