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
