[sql] NULL value for int in Update statement

Is it possible to set NULL value for int column in update statement?

How can I write the update statement in this case?

This question is related to sql sql-update

The answer is


Provided that your int column is nullable, you may write:

UPDATE dbo.TableName
SET TableName.IntColumn = NULL
WHERE <condition>

If this is nullable int field then yes.

update TableName
set FiledName = null
where Id = SomeId

By using NULL without any quotes.

UPDATE `tablename` SET `fieldName` = NULL;