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
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;
Source: Stackoverflow.com