Skip to content
JaiSchool
  • Home
  • SQL

sql null

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

Categories SQL Tags IS NOT NULL, IS NULL, null handling in sql, sql null Leave a comment

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

Categories SQL Tags AUTO_INCREMENT, PRIMARY KEY(), SQL NOT NULL, sql null Leave a comment

Best Hosting To Host Your Blog

© 2021 JaiSchool • Built with GeneratePress