I want to LOAD DATA from text file some columns in row having more than 4000 characters, which is breaking as next line. Even I if open notepad the data in there also showing as next line and having some space in some places.
Not sure, do I need to fix the text file or load data command. It is a windows server. Any suggestions pls?
Input file text: I have hidden the words, I cannot capture everything from notepad, since I did not used word warp. You can see ID ex: 9,10,11. For characters I have used longtext data type for all columns.