IN THIS POST, I have explained how to write NOT NULL column “constraint” correctly. Before that, a NULL value means you have not supplied any value or un-known.
NOT NULL is a column constraint. So that user need to enter some value.
Best Example
Create Table Artist
(artist_id int not null,
dob date not null,
salary int);
So the artist table does not allow null values for artist_id and dob. You must enter values.
SQL NOT NULL Audio
The salary column is different, where it allows null values when you do not enter any amount.
Table Data of Artist
artist_id | DOB | Salary |
1001 | 2000-01-19 | 10000 |
1002 | 2001-07-20 | <null> |
1003 | 2003-05-15 | <null> |
Summary
- NOT NULL is a column constraint
- Without values in the columns where NOT NULL defines, the SQL gives errors.
- By default, all the columns accept NULL values
Related Posts
One thought
Comments are closed.