NULL value for int in Update statement

Question

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

How can I write the update statement in this case?

Answer 1

Assuming the column is set to support NULL as a value:

UPDATE YOUR_TABLE    SET column = NULL 

Be aware of the database NULL handling - by default in SQL Server, NULL is an INT. So if the column is a different data type you need to CAST/CONVERT NULL to the proper data type:

UPDATE YOUR_TABLE    SET column = CAST(NULL AS DATETIME) 

...assuming column is a DATETIME data type in the example above.

Answer 2

By using NULL without any quotes.

UPDATE `tablename` SET `fieldName` = NULL;