LOAD DATA problem

Hello everybody, I’m 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

Re: LOAD DATA problem

-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 from a

Re: Load Data Problem

* [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

Load Data Problem

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

Load Data Problem

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

Re: Load Data Problem

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

Re: Load Data Problem

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 fix

Re: Load Data Problem

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 question and it didn't

Re: Load Data Problem

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

Strange LOAD DATA problem

I have a file (data.txt) which contains the data: ELITEô85.ôQô4 DaysôLilleshallôChris IMPô75.ôQôTuesFriô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 TABLE

RE: Strange LOAD DATA problem

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) because the data MAY

Re: Strange LOAD DATA problem

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ôTuesFriô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: