Chapter 7: Adding, Changing, and Deleting Data

Changing a column’s value to NULL

To set a column value to NULL, use the update statement:

set column_name = {expression | null}
[, column_name = {expression | null}]...

For example, to find all rows in which the title_id is TC3218 and replace the advance with NULL:

update titles 
set advance = null 
where title_id = "TC3218"