Hi Michael,
Have you tried the link at the bottom of every email? If not then have you
looked here? http://lists.mysql.com/faq.php
Shouting at everybody who chooses to subscribe (which you have at some stage)
doesn't help
Regards
---------------------------------------------------------------
********** _/ ********** David Logan
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ******
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia
i n v e n t
---------------------------------------------------------------
-----Original Message-----
From: Michael Price [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 31 May 2006 9:53 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Take my name off your list !!
----Original Message Follows----
From: "Neeraj" <[EMAIL PROTECTED]>
To: "'Harish TM'" <[EMAIL PROTECTED]>,"'sheeri kritzer'"
<[EMAIL PROTECTED]>
CC: <mysql@lists.mysql.com>
Subject: RE: Problem in using LOAD DATA LOCAL INFILE
Date: Wed, 31 May 2006 17:20:39 +0530
Hi harish
Thanks for reply
By executing this query for this table I am not getting any error..
But I am getting wrong result.
I have tried many combinations for LOAD DATA LOCAL INFILE but I am getting
the results in two ways...
1. all the data getting loaded in first columns of first row.
Or
2. data for all columns getting loaded in first column only and getting
error line now data for other columns
Hope you will find the solution
Cheers.:)
Neeraj Black Bits
-----Original Message-----
From: Harish TM [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 30, 2006 10:23 PM
To: sheeri kritzer
Cc: Neeraj; mysql@lists.mysql.com
Subject: Re: Problem in using LOAD DATA LOCAL INFILE
I went through a lot of trouble with Load data local infile... There are a
lot of things regarding Local that MySql does not allow due to security
reasons. As mentioned before this you could give us the error... that might
help
alternatively try out mysqlimport
http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html
Its similar but a lot easier to use.
However its a program so embedding it in code is not efficient..
hope this helps
harish
On 5/30/06, sheeri kritzer <[EMAIL PROTECTED]> wrote:
>
> What's the error you are getting? What MySQL version are you using?
>
> On 5/26/06, Neeraj <[EMAIL PROTECTED]> wrote:
> > Hi all
> >
> >
> >
> > I have a table with following structure
> >
> >
> >
> > CREATE TABLE `dsc` (
> >
> > `ch_code` varchar(255) default NULL,
> >
> > `name` varchar(255) default NULL,
> >
> > `inof` blob
> >
> > ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
> >
> >
> >
> > And I have give a text file with following format
> >
> >
> >
> > Ü
> >
> > ¢
> >
> > Ch.Code :02Ü
> >
> > MEATÜ
> >
> >
> >
> > 1 COUNTRY : JORDAN
> >
> >
> > 2 COUNTRY : SAUDI ARABIA
> >
> >
> >
> >
> >
> > Ü
> >
> > ¢
> >
> > Ch.Code :03Ü
> >
> > FISHÜ
> >
> >
> >
> > 1 COUNTRY : JORDAN
> >
> >
> >
> >
> > Ü
> >
> > ¢
> >
> > Ch.Code :04Ü
> >
> > FISHÜ
> >
> >
> >
> > 1 COUNTRY : JORDAN
> >
> >
> > 2 COUNTRY : SAUDI ARABIA
> >
> >
> >
> > ...
> >
> >
> >
> > I am trying to import the text file into table. I have tried various
> ways
> > but unable to find the solution. the code I am trying to import the
file
> is
> > as follows
> >
> >
> >
> > LOAD DATA LOCAL INFILE 'd:\\data3.txt' INTO TABLE dsc FIELDS
TERMINATED
> BY
> > 'Ü\n' LINES TERMINATED BY '¢\n' (ch_code, name, info);
> >
> >
> >
> > Can any one help me in loading this file...
> >
> >
> >
> > Regards
> >
> >
> >
> > Neeraj Black Bits
> >
> >
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
