How to Insert Null Value into a Column which already have a Value using MySQL

Question

Lets just say I have a row which looks like this:

ID(Long), serialNumber(Long)
1           123

I want to update this row with (1,null). How can I do it? So far from my research, I save that on Update, but it ignores null values.

I doing the update from sql statment using Java, the update ignores null values. — user1125331, Feb 04 '15 at 22:45
Are you looking for this http://stackoverflow.com/questions/11961486/binding-null-in-java-for-mysql-preparedstatment ? — Hotdin Gurning, Feb 04 '15 at 22:47
possible duplicate of [How to update column with null value](http://stackoverflow.com/questions/3870540/how-to-update-column-with-null-value) — Rigel1121, Feb 05 '15 at 01:30

score 0 · Accepted Answer · answered Feb 05 '15 at 01:24

0

Try this one. It works:

UPDATE your_table
SET    
serialNumber = null
WHERE  ID = 1;

answered Feb 05 '15 at 01:24

Rigel1121

I am doing insert with a flag to the statement of "update if exists" so I am not calling directly to update statement. – user1125331 Feb 05 '15 at 03:04
You can't Insert a value into a column which already have a value. Unless, what you're trying to say is to Insert another row on which if serialNumber is exist to any of the row, then the serialNumber of a newly inserted row will now be equal to null. Is that so? – Rigel1121 Feb 05 '15 at 03:26

1 Answers1