You need to specify the columns you're loading, if they aren't all the columns in the table in the same order. So, you need to add
(date, appleprice, orangeprice,pearprice) at the end of your LOAD DATA INFILE statement. As for only loading one row, I'd guess your input file line endings don't match what you specified. See http://www.mysql.com/doc/L/O/LOAD_DATA.html Michael On Fri, 22 Feb 2002, Craig Westerman wrote: > 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 > --------------------------------------------------------------------- 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
