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';");