I have a table that has following fields id (auto increment) date appleprice orangeprice pearprice
When I try to LOAD DATA INFILE with this file using comma as field delimiter and newline as end of row "2000-01-04","281.08","5.27","430.05" "2000-01-05","280.06","5.14","421.98" "2000-01-06","279.99","5.13","408.59" "2000-01-07","281.72","5.14","415.79" "2000-01-10","281.32","5.17","415.80" "2000-01-11","282.83","5.16","416.36" "2000-01-12","281.64","5.14","419.70" "2000-01-13","283.27","5.11","421.50" "2000-01-14","283.25","5.13","429.09" "2000-01-17","284.99","5.10","430.91" "2000-01-18","285.75","5.10","432.21" it only writes to one row in the table and seems to be adding the id fields and date fields. pearprice field is empty. This is result of the one row affected id date appleprice orangeprice pearprice 127 2028-01-08 5.27 430.05 Is my data formated incorrectly? Help! Can someone please show me example of their mysql data in a working situation? Thanks Craig --------------------------------------------------------------------- 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
