A few lines of my CSV:
"id","date","date_","pow","ene","reac"
"ES0134000563024539AM0F","2013-05-02","2013-06-05","62","43","43"
"ES0134000573024539AM0F","2013-05-02","2013-06-05","62","43","43"
"ES0134000563224539AM0F","2013-05-02","2013-06-05","62","43","43"
I tried to import text file but I've received an error message with code 1261. I used the following control characters:
- Fields terminated by:
"
- Fields enclosed by:
,
- Fields escaped by:
"
- Lines terminated by:
\r\n
,
not by"
. – oNare Jul 30 '15 at 12:51"
. It is unclear whether "escaped" is set correctly. – Rick James Aug 1 '15 at 0:11