I have a
mysql 5.7 server.
I am trying to import some
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.