I have a mysql 5.7 server.
I am trying to import some .csv files.
Sometimes it may so happen that these are malformed.
Here is a sample case:
- 'mysql: [Warning] Using a password on the command line interface can be insecure.'
stdout: |-
Warning (Code 1366): Incorrect integer value: ' are not separated per hour."' for column 'story_points' at row 10
Warning (Code 1262): Row 10 was truncated; it contained more data than there were input columns
stdout_lines: <omitted>
What I noticed is that the row was indeed somehow transformed and inserted (although in a bad way).
How can I prevent this behavior? I want the entire command to fail in such cases cause I cannot selectively roll back such malformed insertions.
