MySQL Decimal, Double, Float Rounding Problem

When importing CSV with decimal values to MySQL, the numbers are rounded. I have searched on google but didn’t find a solution so I have come up with my own.

In CSV file decimal part is seperated with a comma “,” , however MySQL accepts a dot “.”.
So just replace commas with dots in your CSV file. That easy 😉


sed -i 's/,/./g' your_file.csv