In order to avoid errors. Always use fields terminated by, enclose by and lines terminated by tag with load data local infile. Just, give try.
On Wed, Sep 24, 2008 at 11:19 AM, Zhongyi Zhang <[EMAIL PROTECTED]> wrote: > I loaded data into table by using "LOAD DATA LOCAL INFILE '../../...TXT' > INTO TABLE tblname (NAME, STREET, MESSAGE);" I found that the first letter > in message disappeared. the message is text. Could anyone tell me why and > how to avoid such problem? > > Thank you > > zzy > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- Krishna Chandra Prajapati
