How to update column with null value

Question

I am using mysql and need to update a column with a null value. I have tried this many different ways and the best I have gotten is an empty string.

Is there a syntax to do this?

Answer 1

Hello @kartik,

CREATE TABLE your_table (some_id int, your_column varchar(100));

INSERT INTO your_table VALUES (1, 'Hello');

UPDATE your_table
SET    your_column = NULL
WHERE  some_id = 1;

SELECT * FROM your_table WHERE your_column IS NULL;

| some_id | your_column |

|       1 | NULL        |
 

Hope it helps!!

Thank you!!