What is the difference between null and not null | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

What is the difference between null and not null

will you plz any explain these in sql

5th Jun 2018, 3:26 AM
Venkata Sukesh Battula
Venkata Sukesh Battula - avatar
4 Answers
+ 3
NULL means that database columns can hold NULL values . NOT NULL means a column to NOT accept NULL values.
5th Jun 2018, 3:54 AM
Sudarshan Rai
Sudarshan Rai - avatar
+ 2
Null in other way means zero or empty value. Thus, Null means you can leave that field empty. And Not Null means you can't leave the value of that field empty. E. g when you fill a form online, there is an asterisk(*) shown near Name field, password, etc., so that field is not null, those values are important and should be filled.
5th Jun 2018, 4:38 AM
Abhishek Rawat
Abhishek Rawat - avatar
0
i can understand Will you plz give me any examole for these
5th Jun 2018, 4:12 AM
Venkata Sukesh Battula
Venkata Sukesh Battula - avatar
0
Okay tq bro
5th Jun 2018, 4:42 AM
Venkata Sukesh Battula
Venkata Sukesh Battula - avatar