Re: Loading Decimal Values with load data infile

2005-09-14 Thread lists . mysql-users
Hallo Thorsten, Op 14 Sep 05 schreef Thorsten Moeller aan MySQL Mailinglist: TM> i am trying to load a csv file with "LOAD DATA INFILE". This File TM> contains columns with decimal values with the german comma instead of TM> the dot as separator (e.g. 3.20 is 3,20). Is there an option to handl

Loading Decimal Values with load data infile

2005-09-14 Thread Thorsten Moeller
Hi, i am trying to load a csv file with "LOAD DATA INFILE". This File contains columns with decimal values with the german comma instead of the dot as separator (e.g. 3.20 is 3,20). Is there an option to handle this during or immediately before LOAD with MySQL Commands/Tools. Now we only see value

Loading Decimal Values with load data infile

2005-09-14 Thread Thorsten Moeller
Hi, i am trying to load a csv file with "LOAD DATA INFILE". This File contains columns with decimal values with the german comma instead of the dot as separator (e.g. 3.20 is 3,20). Is there an option to handle this during or immediately before LOAD with MySQL Commands/Tools. Now we only see value