title: Inserting multiple rows to mysql table from csv file
body: <p>I am using the following query to upload data to mysql from csv file. The csv file has more than one columns separated as follow:</p>
  
  <p>csv file:</p>
  
  <pre><code>1,2
  3,4
  5,6
  </code></pre>
  
  <p>mysql query:</p>
  
  <pre><code>load data infile 'D:\abc.csv' INTO TABLE asdb.abc FIELDS TERMINATED BY ',' lines terminated by '\n' (text,price);
  </code></pre>
  
  <p>the query inserts the values to the table, but at the end of last column of every row it inserts a strange symbol(couldnot post the screenshot as i am new to SO and dont have reputation point,), after 2 and 4 a music like symbol is inserted.</p>
  
  <p>Can anyone please suggest me how to remove that. Also is there any way to insert the values into the table where the csv file is like below:</p>
  
  <p>csv file:</p>
  
  <pre><code>1,2,3,4,5,6
  </code></pre>
  
  <p>Thanks, Biswa</p>