title: LOAD DATA LOCAL INFILE lines terminated by /n
body: <p>I have the following code to write to a file:</p>
  <pre><code> each_file.write(url+&quot;|*|&quot;+rep_name+'|*|'+b['_source']['dataset']['ID']+'|*|'+ title+ '|*|'+ description+&quot;\n&quot;)
  </code></pre>
  <p>Then, I will load this file into MySql using:</p>
  <pre><code>cursor.execute (&quot;LOAD DATA LOCAL INFILE '%s' INTO TABLE testseprator FIELDS TERMINATED by '|*|' LINES TERMINATED BY '\n' (link,repo_name,dataset_id,title,description) SET id = NULL&quot; %(file1,))
  </code></pre>
  <p>which file1 refers to my file path.
  Now, as you can see in the screenshot below:<a href="https://i.stack.imgur.com/O9g7j.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/O9g7j.png" alt="output screenshot" /></a></p>
  <p>there is lots of new lines in my file, now, when I insert this data into MySql the table is messed up! I have description text into my link column, ....
  I think, it is because of new lines that I have in description! how can I fix this problem? I used description1=str(description.strip().strip(&quot;&quot;)), but, this did not help!</p>