NULL data field

[holibub]

Quick question hopefully someone can shed some light on:

In a MySQL database, I have a date field (MyDate) that allows nulls. However, when running a PHP to update that field from a webpage, instead of updating the field with a NULL value, it instead updates with 0000-00-00.

I am told that it is because MySQL defaults to this. Any suggestions on how to get around this?

Thnks.

[Lars_Berg]

Use an explicit null in your statement, e.g.

insert into ogrish(dateColumn,oc1,oc2) values(null,'Magdur','Crepert')