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?
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
