title: Importing a csv file into database mysql
body: <p>Well my question seems simple</p>
  
  <p>I have my csv file located in /etc/myData.csv</p>
  
  <p>I have my code </p>
  
  <pre><code>USE assessment; 
  
  DROP TABLE IF EXISTS test_data; 
  CREATE TABLE test_data (
      ProductID int,
      ProductName varchar(255)
  );
  
  mysqlimport assessment  '/src/myData.csv';
  
  SELECT * FROM test_data;
  </code></pre>
  
  <p>I tried <code>msqlimport</code> but it gives me syntax error.</p>
  
  <p>I even tried this command</p>
  
  <pre><code>mysqlimport  --fields-terminated-by=, assessment  /src/test_data.csv ;
  </code></pre>
  
  <p>Again syntax error. What's wrong with it?</p>
  
  <p>FYI: I already know <code>LOAD</code> command but I want to know other mysql command to import data.</p>