i have a .csv file with rows like this:

16.11.2015 00:00:01.118,0.94674,0.94641,1000000.0000,1750000.0000

now i'd need to import the values to mysql database to a table with 9 cols so:

col1 - 16.11.2015
col2 - 00
col3 - 00
col4 - 01
col5 - 118
col6 - 0.94674
col7 - 0.94641
col8 - 1000000.0000
col9 - 1750000.0000

has anyone an idea how to separate the values f.e. with standard command like :
load data infile 'file.csv' into table nameoftable fields terminated by ',';

i tried to look for something on mysql knowledge base but no resuld, which would be work...thanks