Inserting Null values into table

Database

Inserting Null values into table

I am periodically updating one of my test table. When I insert a new record one of the fields is NULL. Can anyone tell me how to insert a NULL value to the field.?
1 REPLY
N/A

Re: Inserting Null values into table

You can insert NULL values like below :

insert into tablename values (123,NULL,NULL);

Here 2nd and 3rd columns will be inserted as NULL values.