So is there a place where MySQL stores all warning messages which occured
during LOAD DATA ?
-Arnis
>
> Hi
>
> This is not a response to Malcolm, but rather a query.. if the CSV file
> to be imported into a MySQL table using LOAD DATA command had ASCII
> char(13) and/or ASCII char(10) in it, would this interfere with the
> usual behavior of LOAD DATA?
>
> If so, is there a workaround for this problem? (In Oracle, using the
> same command, it's a problem getting this to work...)
>
> Thanks in advance and please CC in your replies.
>
> Noor
>
> On Fri, 26 Jan 2001, Malcolm Edwards wrote:
>
> > I'm loading a large csv file and get the following result:
> >
> > mysql> LOAD DATA LOCAL INFILE "kanji_all.csv" INTO TABLE kanji_all
> > -> FIELDS TERMINATED BY "," ENCLOSED BY "\"" IGNORE 1 LINES;
> > Query OK, 6355 rows affected (1.27 sec)
> > Records: 6355 Deleted: 0 Skipped: 0 Warnings: 49821
> >
> > The resulting table looks fine (hard to tell), but I'd like to
> know what
> > all the warnings are. I've looked though the manual, book, tried logs
> > etc. but I can't find their content.
> >
> > (mysql Ver 10.8 Distrib 3.23.22-beta, for redhat-linux-gnu (i386))
> >
> > Thanks in advance,
> >
> > Malcolm
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
