myodbc cygwin

e too. The error in "make" is: "execute.c:721 : error: conflicting types for `sqlputdata` make [2] leaving directory ..." Many thanks for help, Jan ___________ Dr. Jan Bartholdy Freiheitsweg 64 16515 Oranienburg OT Friedrichsthal phone +49 3

mysql cygwin

I want to use a mysql database in a cygwin application (GRASS). Should I install mysql under cygwin or does exist any possibilities to use the database with myodbc under cygwin only? Thanks, Jan Virus checked by G DATA AntiVirusKit Version: AVK 15.0.5403 from 10.06.2005 -- MySQL

mysql under cygwin

Hi, has anybody any experience with mysql in cygwin (on a windows xp computer). I was able to compile the binary, apache is present in cygwin, but mysql does not work. The newest version of cygwin inc. the xserver ist installed already. Many thanks, Jan Virus checked by G DATA AntiVi

innoDB and referential action

Dear All, I have two tables entity1 and entity2; the second one should contain only data with the same "PLZ" as listed in table "entity1". Unfortunately, I am able to insert in table entity2 data in the field "PLZ", different from those in the field PLZ in the table "entity1". What is going wrong

LOAD DATA or INSERT?

and add the content of the species-column using a command, without editing of the files? Thanks, Jan ___ Dr. Jan Bartholdy University of Bonn Institute of Paleontology Nussallee 8 53115 Bonn Germany phone +49 0228 76 fax +49 3301 808130 cellphone

WG: select case consider the first field only, MySQL 4.0.18

e the inventar of the whole area, but not all are present in each single sample (row). I want to select only columns from single rows, containing values > 0, or not NULL. Thanks for the help, Jan > -Ursprüngliche Nachricht- > > Von: Roger Baklund [mailto:[EMAIL PROTECTE

select case consider the first field only, MySQL 4.18

Dear List, I have a select case question SELECT CASE WHEN `Species_1_l` > 0 THEN 'intern' when 'Species_3_e' > 0 THEN 'extern' ELSE '' END AS `species_1_l` from species where statsample=1820; The result is only -- species_1_l int

select only values >0

Dear All, from a single row of a table, I have to select only the column, which have a value larger '0' into an outfile. How can I manage it with 'select'? Thanks, Jan Virus checked by G DATA AntiVirusKit Version: AVK 15.0.2975 from 09.02.2005 -- MySQL General Mailing List For lis

selection problem

Dear All, I have the following problem: The table in a database is organized like this one: Sample species_species_b species_c A1 0 5 0 A2 0 0 3 A3 1 1 5 I woul