MySQL Database

MySQL Not Null

Require a column to contain a value.

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

An insert that omits a required value fails unless a valid default is supplied.