Ok, so maybe I'm just lazy, but I was wondering if there was any way to load data into a table from a CSV file that has more fields per line than the table that I want to load it into. Can this be achieved using mysqlimport or the LOAD DATA command? Example; INPUT.CSV field1,field2,field3,field4,field5,field6,field7,field8,field9,field10 DATABASE TABLE field2,field3,field4,field5,field6,field7,field10 James E Hicks III Noland Company 2700 Warwick Blvd Newport News, VA 23607 757-928-9000 ext 435 [EMAIL PROTECTED] --------------------------------------------------------------------- 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
