MySQL Ignore Option ... ignore any ignorable errors

I want to insert new record data into an MySQL table which may also hold objects with empty values, i.e.:

Screenshot 2022-11-28 at 07.59.57

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 …

Screenshot 2022-11-28 at 07.52.21

especially the ‘ignore any ignorable errors’ bit :wink:

Thanks in advance, and enjoy your day!

I figured out that adding the Ignore option solves this issue, but I’m wondering what this option does exactly.

Hi @dickhoning, this option would add the IGNORE clause to the INSERT statement generated by the node. You can check out the MySQL docs for a full explanation.

1 Like

Hi @MutedJam thanks! I will investigate this further.

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.