problem with importing text and CSV- files into mysql !!
Hello everybody,
I have a problem with importing text and CSV files into mysql. I always get the error 1064 or the file is not inserted correctly in the MySQL table (All file columns are inserted in the first MySQL column).
I tried to change the DELIMITER (comma instead of semicolon) and still there was no improvement. I use the MyQL Workbench and HeidiSQL. Both of them without success. A times it has worked by changing the region in Windows and in English (American), but I live in Germany I would not stay the region so. Does someone know a solution? Thank you very much
Subject
Written By
Posted
problem with importing text and CSV- files into mysql !!
October 09, 2016 07:36AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.