title: How to import txt file into MySQL keeping the special characters
body: <p>I want to import a txt file into mysql database using command</p>
  
  <pre><code>LOAD DATA LOCAL INFILE 'c:/mydatabase.txt' INTO TABLE mytable COLUMNS TERMINATED BY '\t'
  </code></pre>
  
  <p>However, one column of the data is a filepath which contains special character like "\". I found the import command above just skipped all the "\" in the pathname string. </p>
  
  <p>Is there any way to keep the special charater when import data to mysql? </p>