I'm using the: LOAD DATA LOCAL INFILE "/home/filename.txt" INTO TABLE list; which works just fine. Only problem is the date column which is formatted as such "4/11/1970" comes out as "0000- 00- 00"
The date field is setup as Field: "s_date", Type: "date", Null, "YES", Key: BLANK, Default: "Null", Extra BLANK. Any ideas on how to resolve this? Thanks --------------------------------------------------------------------- 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