Question: how to export csv file to mysql database?
Answer: Start by opening the MySQL shell, then switch to the database you want to export. Enter the following statement: SELECT * FROM myTable INTO OUTFILE '\tmp\myExportFile. csv' FIELDS ENCLOSED BY '"' TERMINATED BY ';' ESCAPED BY '"' LINES TERMINATED BY '\r\n';