mysql version 3.23.41 ...i am having a problem importing simple date and text data ( 6 fields) (from access 97). this is what i have tried:
load data local infile 'client.txt' into table client fields terminated by '\t'; all 9 records imports correctly except that the quotes are still around the data in each field (records: 9 warnings:0) . so i tried again and typed this: load data local infile 'client.txt' into table client fields terminated by '\t' enclosed by '"'; only every other line imported correctly and there was a quote around the beginning of the first field of the data and then another quote and the end of the last field of the record. there were no quotes around the rest of the data in-between the beginning and ending fields. Query OK 5 rows affected Records:5 Warnings: 4.. then i tried: load data local infile 'client.txt' into table client fields terminated by '\t' enclosed by '"' lines terminated by '\n'; the results were still 5 rows ok ad 4 warnings i have also tried using a comma instead of a tab for the "fields terminated by". but that didn't make any difference. --------------------------------------------------------------------- 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
