Hello all,
When i try to import from a field with selected fields on and local file off i get a error.
Error
MySQL said: You have an error in your SQL syntax near ')' at line 7.
Query: LOAD DATA INFILE '<'...mypath:)>/cgi-bin/admin/testexcel.tab' IGNORE INTO TABLE Links FIELDS TERMINATED BY
'\\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 1 LINES ()
Question 1: Is there a bug when you try to import with selected fields or something else ?
Note: when i give a none existing filename it display the same error !
Question 2: Is the record delimter \n when i use a exported excel file .tab or something else (") ?
Regards Startpoint.
When i try to import from a field with selected fields on and local file off i get a error.
Error
MySQL said: You have an error in your SQL syntax near ')' at line 7.
Query: LOAD DATA INFILE '<'...mypath:)>/cgi-bin/admin/testexcel.tab' IGNORE INTO TABLE Links FIELDS TERMINATED BY
'\\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 1 LINES ()
Question 1: Is there a bug when you try to import with selected fields or something else ?
Note: when i give a none existing filename it display the same error !
Question 2: Is the record delimter \n when i use a exported excel file .tab or something else (") ?
Regards Startpoint.