Insert empty value into mysql date field?

Question

I need to insert an empty value into a date field.

I've read how to insert an empty value in mysql date type field? which states to set the field to allow null. I've done that.

It also states to isnert null rather than an empty value. Unfortunatly that's not possible with the current set up - is there a way to allow it to input an empty string?

"Not possible with the current setup" , why? what is your current setup? . No, it's not possible to insert a string into a date column, either insert `NULL` , or change it to a string column(which is not recommended at all!) — sagi, Nov 29 '16 at 14:34

score -1 · Answer 1 · answered Nov 29 '16 at 14:40

-1

Say, your table is:

CREATE TABLE MyTable (A INT ,
                      B INT ,
                      C INT
                     ) ;

The statement:

INSERT INTO MyTable (B,C) VALUES (3,4) ;

will leave A null.

answered Nov 29 '16 at 14:40

FDavidov

3,505
6
23
59

Nothing to do with the question. – panthro Nov 29 '16 at 14:49
By the way, a NULL value is `NULL` and an empty value is `''`. – FDavidov Nov 29 '16 at 16:33

Insert empty value into mysql date field?

1 Answers1