At 10:32 AM -0500 10/31/01, <[EMAIL PROTECTED]> wrote:
>Hi
>
>I'm working on importing csv datafile returns Warnings, after carefully
>checking data I noticed that there are double quotes (") inside the
>records.
>
>mysql> LOAD DATA INFILE '/home/sql/data.csv' INTO TABLE csvdata
>FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n';
>Query OK, 20000 rows affected (1.58 sec)
>Records: 20000 Deleted: 0 Skipped: 0 Warnings: 572
>
>Example of line that fails:
>"data","data","some "text" and" text"\n
>
>Any quick solutions, regarding mysql import?
It's not surprising that it fails. It's not valid CSV.
>
>Thanks
>
>sql,table,database,query,mysql
---------------------------------------------------------------------
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
