not

UK[n?t] US[nɑ:t]

adv.No; [used to express negation, denial, rejection, prohibition, etc.] No ; Hardly; Not necessarily, no [used to negate the following word or phrase]

null

UK[n?l] 美[n?l]

adj.<Art>zero value; equal to zero; (agreement) has no legal effect; invalid

mysql NOT NULL constraint syntax

Function: Constraint forces the column not to accept NULL values.

Description: NOT NULL constraint forces the field to always contain a value. This means that you cannot insert a new record or update a record without adding a value to the field.

mysql NOT NULL constraint example

//強(qiáng)制 "Id_P" 列和 "LastName" 列不接受 NULL 值
CREATE TABLE Persons(Id_P int NOT NULL,LastName varchar(255) NOT NULL,FirstName varchar(255),Address varchar(255),City varchar(255));