sql null Archives - JaiSchool

Handling NULL values in SQL

22/08/2020 by JaiSchool

If a column’s field has NULL value then it means, it is blank. This field has no value. When a column’s value is NULL then it can’t be determined by an eqal to (=) operator. The way of identifying NULL values is, you need to use IS NULL or IS NOT NULL statement. NOT NULL … Read more

SQL NULL, AUTO_INCREMENT & PRIMARY KEY()

29/07/2020 by JaiSchool

NULL :- When a table contains two or more columns and we insert data into only one column then data in the second column will be automatically inserted as a NULL value. NOT NULL & AUTO_INCREMENT:- When we want to make column auto-increment then it needs to be disabled its ‘NULL‘ feature. Write NOT NULL … Read more