update to null mysql

NULL is a special value in SQL. So to null a property, do this:

UPDATE table SET column = NULL;

The MySQL manual states that if the column does not allow NULL values, setting it to NULL will result in the default value for the data type (e.g. an empty string). 

Leave a Reply