MySQL updating nullable date column to NULL
<p>I have a nullable date column in a MySQL InnoDB table. How do I update that column to NULL when issuing an update?</p>

<pre><code>UPDATE memo_codes_student SET `resolved_date_client` = NULL, `status` = 'Rejected' WHERE `guid_enrollment` = @guid_enrollment AND `guid` = @itemGUID
</code></pre>

<p>When I run the statement above, it updates the field to 0000-00-00. How can I get it to update the field to NULL?</p>