Re: Importing CSV files to MySql Db issue.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

Still stuggling,

Thanks,

Chris



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
>> through
>> CSV upload and not CSV Load Data:
> 
> Eh? You're using the csv table type or how are you importing the 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
> 
> If you're using spaces for enclosing then I'm sure you're not handling 
> something properly.
> 
> Chris,Carter,email@xxxxxxxxxxx <-- 3 records
> Chris Carter,email@xxxxxxxxxxx <-- 2 records
> 
> The second one is probably going to break because of the space in the 
> middle of the name.
> 
> -- 
> Postgresql & php tutorials
> http://www.designmagick.com/
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Importing-CSV-files-to-MySql-Db-issue.-tp15514806p15538890.html
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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux