Importing csv file into mysql: Incorrect decimal value: '"0.5'
<p>Can someone point me what I am doing wrong:
csv file:</p>

<pre><code>weight,student,price
0.5,4,2.3
</code></pre>

<p>command:</p>

<pre><code>LOAD DATA INFILE 'prices.csv'
            INTO TABLE prices
            FIELDS TERMINATED BY ','
            LINES TERMINATED BY '\n'
            IGNORE 1 ROWS;
</code></pre>

<p>Error:</p>

<pre><code>Incorrect decimal value: '"0.5' for column 'weight' at row 1
</code></pre>