how to populate table in mysql with csv file code example
Example: how to populate a table in MySQL from and existing csv file
loaddata localinfile’YouCSVFileName.csv’into table ReplacewithT fields terminated by’,’enclosed by’"’;
loaddata localinfile’YouCSVFileName.csv’into table ReplacewithT fields terminated by’,’enclosed by’"’;