How to update a column with a "blank" value

Question

How do I update a column value (varchar(20), not null) with a "blank" value?

[how-to-empty-a-column-in-mysql](http://dba.stackexchange.com/questions/54111/how-to-empty-a-column-in-mysql) — here, Dec 17 '15 at 20:37

score 8 · Answer 1 · answered May 14 '11 at 04:55

8

If you want to update it with NULL you will need to change it to allow NULL. Otherwise update with an empty string "".

answered May 14 '11 at 04:55

Louis

score 6 · Answer 2 · answered May 14 '11 at 05:10

6

Update TableName Set ColumnName='' where [Condtion] // To update column with an enpty values

answered May 14 '11 at 05:10

Nanda

Mitul Panchal · Answer 3 · 2018-03-23T05:15:42.893

0

If there have any int column which you may want to do null

Update TABLE_NAME set name = '',id = cast(NULLIF(id,'') as NVARCHAR)

edited Mar 23 '18 at 05:15

answered Mar 23 '18 at 04:50

Mitul Panchal

from [this answer](https://stackoverflow.com/a/6054382/1358091), null is int by default so you don't need to cast – Marco Carletti Mar 19 '21 at 09:52

3 Answers3