Import empty string value to MySQL as date

Question

I have a string array that I am importing to a MySQL table, containing strings but also date strings (e.g. '2017-01-01'). Some dates are zero ('') and MySQL does not recognise these as dates. Since I am using a string array I cannot use NULL.

How can I pass a zero date value to my table by using a string value? The result in the table should be null, not '00-00-0000' for example.

Thanks!

I really dont understand where is problem. Both Mysql types DATE and DATETIME can be null so simple if date is "" then insert null into Mysql? — Erik Šťastný
– Erik Šťastný, Commented Mar 24, 2017 at 14:55
Sorry let me be more specific. I am creating a csv file from a string array, and then importing that CSV into MySQL. If the date is '' in the csv file, MySQL does not recognise this as a date and gives an error. — merlot
– merlot, Commented Mar 24, 2017 at 15:12

Erik Šťastný · Accepted Answer · 2017-03-27 10:09:46Z

1

Just add simple condition for check value of date

date = some_date_from_cvs

if date is not "":
    mysql.insert(date)
else:
    mysql.insert(NULL)

answered Mar 27, 2017 at 10:09

Erik Šťastný

1,5041 gold badge19 silver badges42 bronze badges

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

Comments

Hussnain Raza · Accepted Answer · 2017-03-24 14:50:56Z

0

According to my experience, you have to check if the string is empty then simple get the current Date using python script.

import time
## dd/mm/yyyy format
cur_date = (time.strftime("%d/%m/%Y"))
if str is in ['', None]:
    str = cur_date

After getting the date simply import to MYSQL.

answered Mar 24, 2017 at 14:50

Hussnain Raza

12 bronze badges

Collectives™ on Stack Overflow

Import empty string value to MySQL as date

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related