Re: Newbie question: importing cvs settings
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 some screen shots of 2 tests. A workaround solution is to make a final entry in the csv file that I don't really need. Then everything up to that point gets imported ok using CSV method. The LOAD DATA method did not enter anything. My earlier assumption about line 17 was false. It was dependent on how many rows, and I had been using tests with same amount of data. As I said, very beginner level, so thanks for the patience. screenshots at http://biz-comm.com/mysqlprojects/ thank you -- Patrice Olivier-Wilson 888-385-7217 http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Newbie question: importing cvs settings
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 (CMDBA) Certified MySQL 5 Developer (CMDEV) IBM Cognos BI Developer Telephone +44 (0)7812 451238 Email j...@butterflysystems.co.uk -Original Message- From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com] Sent: 27 September 2009 15:19 Cc: 'mysql' Subject: Re: Newbie question: importing cvs settings 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 some screen shots of 2 tests. A workaround solution is to make a final entry in the csv file that I don't really need. Then everything up to that point gets imported ok using CSV method. The LOAD DATA method did not enter anything. My earlier assumption about line 17 was false. It was dependent on how many rows, and I had been using tests with same amount of data. As I said, very beginner level, so thanks for the patience. screenshots at http://biz-comm.com/mysqlprojects/ thank you -- Patrice Olivier-Wilson 888-385-7217 http://biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.409 / Virus Database: 270.13.113/2396 - Release Date: 09/26/09 05:51:00 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Query :: Finding Date Difference
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_packages weight frieght_charges loading_charges unloading_charges tax amount remarks courier_status user_id consignor_email consignee_email status [image: Edit]http://localhost:91/tbl_change.php?db=seva360table=courier_details_t bltoken=dc325199a0d6782e1a4bbb6f96ec0ff8primary_key=+%60courier_details_tb l%60.%60courier_id%60+%3D+1sql_query=SELECT+%2A+FROM+%60courier_details_tbl %60goto=sql.php [image: Delete]http://localhost:91/sql.php?db=seva360table=courier_details_tblto ken=dc325199a0d6782e1a4bbb6f96ec0ff8sql_query=DELETE+FROM+%60courier_detail s_tbl%60+WHERE+%60courier_details_tbl%60.%60courier_id%60+%3D+1+LIMIT+1zero _rows=The+row+has+been+deletedgoto=sql.php%3Fdb%3Dseva360%26table%3Dcourier _details_tbl%26token%3Ddc325199a0d6782e1a4bbb6f96ec0ff8%26sql_query%3DSELECT %2B%252A%2BFROM%2B%2560courier_details_tbl%2560%26zero_rows%3DThe%2Brow%2Bha s%2Bbeen%2Bdeleted%26goto%3Dtbl_structure.php 1 gfdsgdfs gdfsgsdf gdfsg 43534 gdfsg gfdsgs gfdsgdf 5435345 2009-10-02 05 15 -00-00 fadsfads 33 23 23 2 3 3 32 1 1 0 [image: With selected:] Hi All , Above is my table structure , table name is *details_tblhttp://localhost:91/tbl_structure.php?db=seva360table=courier _details_tbltoken=dc325199a0d6782e1a4bbb6f96ec0ff8 * http://localhost:91/tbl_structure.php?db=seva360table=courier_details_tbl token=dc325199a0d6782e1a4bbb6f96ec0ff8 Am working in courier project , Once the goods despatch , then we show the staus as sent , Assume if user , track the courier after 30 day's , Then i have to show the message contact admin , If they tried with in 30 days , then i have to show message , like courier SENT / PEND / FAILED , Can u please tell the query , If the *r_date *(recive date) greater then of 30 days , they i have to show message like contact admin Please tell the query , Thanks Getting answers to your questions is easier if you can show you have done a little backround work to try to find the answer. Case in point: http://lmgtfy.com/?q=datediff+in+mysql Colin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org