Re: Query :: Finding Date Difference

2009-09-27 Thread Colin Streicher
On September 26, 2009 05:10:23 am bharani kumar wrote: > courier_id consignor_name consignor_address consignor_destination > consignor_phone > consignee_name consignee_address consignee_destination consignee_phone > s_date s_date_mm s_date_ss r_date r_date_mm r_date_ss > consignment_description no_

RE: Newbie question: importing cvs settings

2009-09-27 Thread John
Patrice, Can you post the output of SHOW CREATE TABLE for the table you are having difficulty inserting into? Without knowing the table structure its very difficult to work out why your data load is failing. Regards John Daisley MySQL & Cognos Contractor Certified MySQL 5 Database Administrator

Re: Newbie question: importing cvs settings

2009-09-27 Thread Patrice Olivier-Wilson
Back again... I have 192 records to import, and tried my extra line at the end hoping for a work around, but nope, it failed at line 17 again. Invalid field count in CSV input on line 17. Anyone have an idea why this might be happening? Patrice Olivier-Wilson wrote: Yep, typo ...:-( I did