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
Chris,
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
Don't you mean:
Chris,Carter,[EMAIL PROTECTED] -- 3 *fields*
Chris Carter,[EMAIL PROTECTED] -- 2
Gary Wardell wrote:
Chris,
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
Don't you mean:
Chris,Carter,[EMAIL PROTECTED] -- 3 *fields*
Chris
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
Chris Carter wrote:
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.
Then your issue will
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