Hi!
Im trying to import an excel csv file into a mysql db, i'm using the load data mysql command like this:
LOAD DATA INFILE "codigos.csv" INTO TABLE CIUDADES (CIUDAD, CODIGO) FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'
but it doesn't work, i think this happens because the excell carriage return is not the '\n'. Could somebody help me?
thanks for all!
Sorry for my bad english!
Jos?Sabbagh.
Im trying to import an excel csv file into a mysql db, i'm using the load data mysql command like this:
LOAD DATA INFILE "codigos.csv" INTO TABLE CIUDADES (CIUDAD, CODIGO) FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'
but it doesn't work, i think this happens because the excell carriage return is not the '\n'. Could somebody help me?
thanks for all!
Sorry for my bad english!
Jos?Sabbagh.