Sql insert null if blank

In SQL, due to lack of data, we sometimes need to insert rows with NULL values in the tables. Here, the keyword NULL(without quotes) is used to represent no data.

There are some key points of Null value: 

• NULL value is different from a zero value.
• A NULL value is used to represent a missing value, but that it usually has one of three different interpretations:
  • The value unknown (value exists but is not known)
  • Value not available (exists but is purposely withheld)
  • Attribute not applicable (undefined for this tuple)
• It is often not possible to determine which of the meanings is intended.

  Hence, SQL does not distinguish between the different meanings of NULL.

Syntax:

INSERT INTO TABLE_NAME values (COLUMN_VALUE,NULL,........);

Step 1: Create a Database. For this use the below command to create a database named GeeksForGeeks.

Query:

CREATE DATABASE GeeksForGeeks

Output:

Step 2: Use the GeeksForGeeks database.

For this use the below command.

Query:

USE GeeksForGeeks

Output:

Step 3: Create a table WOR

how to insert null value in sql using python

how to insert null value in sql from c