I am not using spaces for closing. Every field is tightly packed with comma
only. No spaces, no semicolon. The reason I used space is if I use space at
least 3 or 4 fields get uploaded but not all. But we can ignore space for
now as it happened earlier.
I am using the CSV import option from MySql admin.
chris smith-9 wrote:
> Chris Carter wrote:
>> Is there something that has changed in the new MySql DB ?
> What new mysql? Has your host upgraded your database version or something?
> Mysql won't change the interface between versions except to improve it.
>> I am trying to upload a data like this from my CSV file to a table
>> CSV upload and not CSV Load Data:
> Eh? You're using the csv table type or how are you importing the data?
>> 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
> If you're using spaces for enclosing then I'm sure you're not handling
> something properly.
> Chris,Carter,[EMAIL PROTECTED] <-- 3 records
> Chris Carter,[EMAIL PROTECTED] <-- 2 records
> The second one is probably going to break because of the space in the
> middle of the name.
> Postgresql & php tutorials
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
View this message in context:
Sent from the Php - Database mailing list archive at Nabble.com.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php