I want to insert new record data into an MySQL table which may also hold objects with empty values, i.e.:
When I try to do this, I get error messages for the empty value, such as
ERROR: Incorrect date value: '' for column 'Date' at row 1
I figured out that adding the Ignore option solves this issue, but I’m wondering what this option does exactly. Anyhow, I could not find it in the documentation. And the following description doesn’t help me either …
especially the ‘ignore any ignorable errors’ bit
Thanks in advance, and enjoy your day!