MySQL : MySQL load data infile loading exactly half the records

MySQL : MySQL load data infile loading exactly half the records
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

Here's a secret feature that I promised to disclose to you.
This is a YouTube's feature which works on Desktop.
First, Make sure this video is playing.
Then, type the letters 'awesome' on your keyboard as the next step.
The progress bar on YouTube will be altered to a flashing rainbow.

Allow me to introduce myself briefly,
Hello, I am Delphi.
I help you answer your questions.
MySQL : MySQL load data infile loading exactly half the records
I welcome your comments and chats if you have more detailed queries.
We appreciate your participation, so please feel free to comment below with your answer or insights.
I will express my appreciation for your answer by 'hearting' it.
the infile MySQL : MySQL exactly half loading load data records