Save .csv file in MySQL

0

I need to save a .csv file in MySQL with the following format:

9044;2018/10/05

The table in the database is as follows:

id_criptomoneda; precio_dolar; fecha

And I execute the following command with the related id of another table but it does not work for me:

mysqli_query($conexion,"LOAD DATA INFILE '../historial/bitcoin/historialBitcoin.csv' INTO TABLE 'criptomoneda' WHERE id_criptomoneda = 1 FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n';");
    
asked by charli 15.05.2018 в 19:28
source

0 answers