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'
> I
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 M
