Import MySQL CSV files

Question

Import MySQL CSV files

Navigation

#1 by (2 votes)

1

I'm using Xampp as a server and MySqlWorkbench as a database, how can I import a csv file to make various experiments (file size, upload time, etc.)?

mysql xampp

asked by anonymous 12.06.2015 / 17:49

1 answer

MVC - Doubt about controller and view PHP Making cmd slower

score 2 · Accepted Answer

There are many ways you can do this, but regardless of how you do it, you first have to create the table with the given structure (columns and fields) so that you can use it with the CSV file or whatever you want to import .

I think this tutorial can help you Importing cvs to mysql

MySQL has a command to import a CSV file directly into a table (and it looks very fast).

LOAD DATA INFILE 'arquivo' INTO TABLE 'tabela'