-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jerome Smith wrote:
> Hello everybody,
>
> Im new to this list, and also new to MySQL. I would be very grateful if
> someone could help me with the following problem:
>
> I have MySQL server version 4.0.12 with a database on a Linux server. I
> work
* [EMAIL PROTECTED]
> Hie there,
> I'm having a potential problem with Load Data Infile function
> where i'm unable to get the right no. of records to appear in the table. I
> have a table created in MySQL with 2 fields region (char 1)-pkey and
> regionname (char 30). The table name is c
Hi,
>I'm having a problem when using Load Data where the single and double quotes
>in the text file are getting nuked. It appears that the escape character is
>not being respected but I'm not sure why. It is also knocking out
>characters near the quotes.
Your single and double quotes come out
G'day All
>"kimtest","Kim","","","this is kim¹s test stories¹ to see how we c¹n
>accommodate single quotes¹ There are a ³couple² of ³double² quotes here
>to. And ³here are some single¹ quotes that¹re enclosed in
>doubles²","2002-4-4","",""
I seem to have found the problem to my own questi
G'day Colin
> load data local infile '~/Documents/web export.txt' into table stories
> fields terminated by ',' enclosed by '"' escaped by '\\' lines
> terminated by '\r'
> (StoryName,Writer,Heading,Caption,Body,ListDate,Section,Publication);
Thanks for your suggestion but sadly it didn't fi
Hi kim,
Try using
load data local infile '~/Documents/web export.txt' into table stories
fields terminated by ',' enclosed by '"' escaped by '\\' lines
terminated by '\r'
(StoryName,Writer,Heading,Caption,Body,ListDate,Section,Publication);
Also, if this is a windows text file you should be us