How to import a CSV file into MySQL? I get error code 1295:
ERROR 1295: 1295: This command is not supported in the prepared statement statement yet SQL Statement
I sent the command:
LOAD DATA LOCAL INFILE 'caminho_do_arquivo' INTO TABLE tabela CHARACTER SET UTF8;
Many mySQL graphical clients have very simple import dialogs (windows) for this kind of thing.
What I use for is the work HeidiSQL .
It provides a graphical interface to build the LOAD DATA command;
You can reuse it programmatically later.
I know this is not the case but check out the formatting of the .csv file before importing it.
To use HeidiSQL for a look at this link in English that has images of an example of importing a .csv file