Importing CSV files to MySql Db issue.
| From: | Chris Carter | Date: | Sat, 16 Feb 2008 04:13:59 +0000 |
| Subject: | Importing CSV files to MySql Db issue. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44607@lists.php.net to get a copy of this message | ||
Is there something that has changed in the new MySql DB ?
I am trying to upload a data like this from my CSV file to a table through
CSV upload and not CSV Load Data:
field1,field2,field3,field4,field5,field,6,field7,field8
field1,field2,field3,field4,field5,field,6,field7,field8
Parameters I am using are:
Fields Terminated By: ,
Fields Enclosed By: _ (space character)
Fields Escaped By: _ (space character)
Every time I am getting this error: Invalid field count in line 1
Is there any other workaround for this.
Please suggest,
Thanks,
Chris
--
View this message in context: http://www.nabble.com/Importing-CSV-files-to-MySql-Db-issue.-tp15514806p15514806.html
Sent from the Php - Database mailing list archive at Nabble.com.