SQL NOT NULL Constraint

NOT NULL constraint enforces a field to always contain a value. This means that you cannot insert a new record, or update a record without adding a value to this field.

SYNTAX :

CREATE TABLE table_name
(column1 datatype NOT NULL,
column2 datatype,
.....
);

Online Execute/Compile
CREATE TABLE Emp (id INT , year INT(20) NOT NULL); INSERT INTO Emp(id) VALUES (10407); SELECT * FROM Emp;

: Scanftree

sql

sql-not-null

SQL

DQL :Data Query

DML :Data Manipulation

DDL :Data Definition

TCL :Transaction Control

DCL :Data Control

SQL others

SQL Function

SQL NOT NULL Constraint

SYNTAX :

Aptitude / Reasoning / Interview

Physical education & sports