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
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
Hi,
i have a file which i need to import in about 7 tables. For this reason
i need toimport only parts of this file into each of the tables.
Is there a way to do this with LOAD DATA INFILE or what would be the
preferred way with just having mysql standard tool at hand??
Cheers
Thorsten
--
htt
