-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
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 from a Windows XP client. I am trying to load data from a text file
into a table
* [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
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 called region. I've also create
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
Hello All,
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.
The command I'm running is:
load dat
At 17:36 + 1/6/02, David Ayliffe wrote:
>I have a file (data.txt) which contains the data:
>
>ELITEô85.ôQô4 DaysôLilleshallôChris
>IMPô75.ôQôTues&FriôLilleshallôSue
>LEFTô0.ôôôLeftô
>PRESCô24.ôTôOne DayôWrekinôArleen
>RECô27.ôQôTuesôWrekinôTony
>
>I use the "LOAD DATA" DDL
Yeah useful but that still doesn't solve my problem
-Original Message-
From: Maciek Dobrzanski [mailto:[EMAIL PROTECTED]]
Sent: 06 January 2002 17:43
To: David Ayliffe; 'MySQL'
Subject: Re: Strange LOAD DATA problem
> Also I use the field delimiter ô (ALT+147) be
I have a file (data.txt) which contains the data:
ELITEô85.ôQô4 DaysôLilleshallôChris
IMPô75.ôQôTues&FriôLilleshallôSue
LEFTô0.ôôôLeftô
PRESCô24.ôTôOne DayôWrekinôArleen
RECô27.ôQôTuesôWrekinôTony
I use the "LOAD DATA" DDL statement:
LOAD DATA LOCAL INFILE "data.txt" INTO TA
12 matches
Mail list logo
