title: Load data error with data containing semi colon
body: <p>Im using the following sql to import the data using "load data" of mysql. The description field contains semi colon, so the contents coming after semi colon is not inserting</p>
  
  <pre><code>LOAD DATA LOCAL INFILE  '/tmp/phpz4m7Rl' INTO TABLE  `mytable` FIELDS TERMINATED BY  ';' ENCLOSED BY  '"' ESCAPED BY  '\\' LINES TERMINATED BY  '\n'
  </code></pre>
  
  <p>Actual data is given below</p>
  
  <pre><code>1;2;3;D;Testdata: Testing; 100% Perfect
  </code></pre>
  
  <p>But it is inserting only </p>
  
  <pre><code>1;2;3;D;Testdata: Testing;
  </code></pre>
  
  <p>My table structure</p>
  
  <pre><code>CREATE TABLE `mytable` (
    `id` text NOT NULL,
    `category` varchar(12) NOT NULL,
    `product` varchar(12) NOT NULL,
    `language` text NOT NULL,
    `description` text NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  </code></pre>
  
  <p>What should I change to get the full data ?</p>