MYSQL/PHP How do I insert a null value?

Question

I'm having problems updating records to contain NULL values - in particular, a field which is of type Date.

I'm using prepared statements and I've tried the following:

// Fails
$value = NULL;

// Fails
$value = "";

// Fails
$value = "NULL";

all 3 of the above result in a date of 1969-12-31 being entered (0). How do I insert NULL values?

What does the definition for your table look like? May you insert a NULL value into this field? — thetaiko
– thetaiko, Commented Mar 10, 2010 at 18:42
Yes, it allows null values. If I go into PHP my admin I can do "update tblA set date_field = NULL" sucessfully, or without prepared statements it works fine. — Stomped
– Stomped, Commented Mar 10, 2010 at 18:43
you're talking about sql here, so could you please show the query you're using to update the row? — Tesserex
– Tesserex, Commented Mar 10, 2010 at 18:43

Community · Accepted Answer · 2017-05-23 12:26:43Z

1

Did you read the following question/answer: using nulls in a mysqli prepared statement

That seems to be the same issue. Correct me if I'm wrong?

CommunityBot

11 silver badge

answered Mar 10, 2010 at 18:44

Josh

11.1k11 gold badges67 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1