Set value to NULL in MySQL

You're probably quoting 'NULL'. NULL is a reserved word in MySQL, and can be inserted/updated without quotes:

INSERT INTO user (name, something_optional) VALUES ("Joe", NULL); UPDATE user SET something_optional = NULL; 

UPDATE MyTable SET MyField = NULL WHERE MyField = '' 

You should insert null, not the string of 'NULL'.

Use NULL (without the quotes around it).

UPDATE users SET password = NULL where ID = 4 

if (($_POST['nullfield'] == 'NULL') || ($_POST['nullfield'] == '')) { $val = 'NULL'; } else { $val = "'" . mysql_real_escape_string($_POST['nullfield']) . "'"; } $sql = "INSERT INTO .... VALUES ($val)"; 

if you put 'NULL' into your query, then you're just inserting a 4-character string. Without the quotes, NULL is the actual null value.

Assuming the column allows a null setting,

$mycolupdate = null; // no quotes 

should do the trick

The answers given here are good but i was still struggling to post NULL and not zero in mysql table.

Finally i noted the problem was in the insert query that i was using

 $quantity= "NULL"; $itemname = "TEST"; 

So far so good.

My insert query was bad.

 mysql_query("INSERT INTO products(quantity,itemname) VALUES ('$quantity','$itemname')"); 

I corrected query to read.

 mysql_query("INSERT INTO products(quantity,itemname) VALUES ('".$quantity."','$itemname')"); 

So the $quantity is outside of the main string. My sql table now accepted to record null quantity instead of 0

The problem you had is most likely because mysql differentiates between null written in capital letters and null written in small case.

So if you used an update statement with null, it would not work. If you set it to NULL, it would work fine.

Thanks.

right click on it and choose "clear field content"