Dear Team,
I am trying to import data into my sql table. HeidiSql 9.3.0.4984 does not set empty Date columns as NULL but marks them with "'" and therefore, I get the following error message.
/ SQL Fehler (1292): Incorrect date value: '' for column 'Date2' at row 1 /
I have shown you part of the sample string that I copied from the log from the bottom, for you to see, where the error is.
I have provided the table information and attached the sample file, which I tried to upload into the DB structure and which fails with above code.
Can you look into this, since I cannot find out, what the problem might be?
Thanks Mike