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]
