I unfortuantely don\'t remember if this questions been asked, but a search found no help, if there is an existing thread, direct me to it please. I am loading text into a BLOB field and have set up the FIELDS TERMINATED BY \"^\", and LINES TERMINATED BY \"~\". I wanted the lines to end up in the same position as in the yext file:
Line one, blah blah.~
Line two, examples.~
Line three, and so on.^
Instead of: Line one, blah blah. Line two, examples. Line three, and so on.~
I need the carrige returns after the line, but everytime i try to load them, mySql reads them as seperate records, and gives me warnings. Am I misunderstanding the line termination delimiter, and if so, how can i get the text to load into the DB in natural form? Much appreciated
Moly-b
Line one, blah blah.~
Line two, examples.~
Line three, and so on.^
Instead of: Line one, blah blah. Line two, examples. Line three, and so on.~
I need the carrige returns after the line, but everytime i try to load them, mySql reads them as seperate records, and gives me warnings. Am I misunderstanding the line termination delimiter, and if so, how can i get the text to load into the DB in natural form? Much appreciated
Moly-b