title: Csv file to MySQL database table
body: <p>Fix the error and i need to import(store) csv files to mysql database table</p>
  
  <pre><code>Class.forName("com.mysql.jdbc.Driver");
      java.sql.Connection c = null;
      c = DriverManager.getConnection("jdbc:mysql://localhost:3306/Sample", "root", "root");
      Statement s = null;
      s = (Statement) c.createStatement();
      int i = s.executeUpdate("load data local infile 'E:\\Book1.csv' into table sample.copy_table fields terminated by ',' optionally enclosed by '"' lines terminated by '\r\n'");
  </code></pre>
  
  <p>Returned errors :<br/></p>
  
  <pre><code>Error:Invalid character constant in this line ("load data local infile'E:\\Book1.csv'.......)
  java.sql.SQLException: Unable to open file 'E:Book1.csv'for 'LOAD DATA LOCAL INFILE' command.Due to underlying IOException: 
  
  ** BEGIN NESTED EXCEPTION ** 
  
  java.io.FileNotFoundException
  MESSAGE: E:Book1.csv (The system cannot find the file specified)
  </code></pre>