Configure error of mysql-connector-odbc-5.1.5r1144 (missing sqlext.h)

2009-09-26 Thread Peng Yu
Hi, I try to configure mysql-connector-odbc-5.1.5r1144, But I got the following error. Can somebody let me know where to download the package which includes sqlext.h? Regards, Peng checking whether the f95 linker (/home/pengy/utility/linux/bin/ld -m elf_x86_64) supports shared libraries... yes c

Re: Newbie question: importing cvs settings

2009-09-26 Thread Patrice Olivier-Wilson
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 w

Re: Is It Possible to create a Join with Multiple Tables

2009-09-26 Thread Arthur Fuller
I don't see why not, but another choice is to create a view that encompasses all these tables and Select * From my_view. Arthur On Fri, Sep 25, 2009 at 11:28 PM, c...@hosting4days.com < c...@hosting4days.com> wrote: > :Newbie: > Short Question: Is it possible to create an inner join (or another j

RE: Newbie question: importing cvs settings

2009-09-26 Thread John
I assume you mean csv not cvs! What is the error you get when the import fails? What version of MySQL are you using? Can you post the output of SHOW CREATE TABLE for the table you are trying to load the file in to and a sample of the csv which is failing to load? Do you get the same error if you

Newbie question: importing cvs settings

2009-09-26 Thread Patrice Olivier-Wilson
Greetings: I have a project for which need to import cvs files into db. I can do so up to a point. The import will only do 16 lines, consistently. Error is failing at line 17. Steps: create table fields in Excel document, where they all match database fields enter information in several of t

Query :: Finding Date Difference

2009-09-26 Thread bharani kumar
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