List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 31 2001 9:11pm
Subject:Re: Load data infile
View as plain text  
At 2:47 PM -0500 10/31/01, <sql@stripped> wrote:
>Hi
>
>I didn't see any difference between using optionally or not.
>
>Any solutions to make the two that fails work? (see test case below)
>
>Using 3.23.41.
>
>Thanks

The problem is that your CSV file isn't legal CSV.  You'll need to
tell your application to generate correct CSV format.

>
>
>test.csv:
>"Record 1","some data","Works"
>"Record 2",""some" data","Works"

This line is illegal.

>"Record 3","some 'data'","Works"
>"Record 4",""some" "data","Works"

So is this one.

>"Record 5",""some"data"","Fails"

And this one.

>"Record 6","some"data","Works"

And this one.

>"Record 7","some data"","Fails"

And this one.

>"Record 8","'som"e"'data","Works"

And this one.

>"Record 9","some"data","Works"

And this one.
Thread
Load data infilesql31 Oct
  • Re: Load data infilesql31 Oct
    • RE: Load data infileJoe Kaiping31 Oct
RE: Load data infileRick Emery31 Oct
Re: Load data infilePaul DuBois31 Oct
Re: Load data infilePaul DuBois31 Oct