NOT NULL indicates that the column cannot have a NULL value for any record; NULL indicates that NULL is a valid value (even when the column has a foreign key constraint).
NULL is defined as "a missing unknown value," and it is treated differently than other values. Because the result of any arithmetic comparison with NULL is also NULL, such comparisons yield no meaningful results. In MySQL, false is 0 or NULL, and true is anything else.
NOT NULL indicates that the column cannot have a NULL value for any record; NULL indicates that NULL is a valid value (even when the column has a foreign key constraint).
In MySQL, you use the ALTER TABLE MODIFY command to remove a NOT NULL constraint for a column and then restate the column definition, eliminating the NOT NULL attribute.
NULL is defined as "a missing unknown value," and it is treated differently than other values. Because the result of any arithmetic comparison with NULL is also NULL, such comparisons yield no meaningful results. In MySQL, false is 0 or NULL, and true is anything else.
Learner's Ratings
4.3
Overall Rating
60%
29%
2%
0%
9%
Reviews
P
PRATIK KUMBHAR
4
perfect for beginner
S
Shaik sarmath
5
is this course sutiable for b.com?
B
Boobalan A
4
I want this course for english. Classes are superb. but not understand few places, because I don't know hindi.
Share a personalized message with your friends.