re are more than 1000 records in my text
file..
Can you help
Cheers
:-)
Neeraj Black Bits
_
From: Harish TM [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 31, 2006 9:54 PM
To: sheeri kritzer
Cc: Neeraj; mysql@lists.mysql.com
Subject: Re: Problem in using LOAD DATA LOCAL
a 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: Tuesd
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 mysqli
: 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
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.
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=Inn
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Ü