Re: Smallest install of mySQL

2003-02-04 Thread Oliver Six
already been ported to the Sharp Zaurus (http://www.caulfei.demon.co.uk/zaurus/index.html); it should run on the yopy also. Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377

Re: load data

2002-09-27 Thread Oliver Six
DATA INFILE 'a.txt' INTO TABLE table FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n'; Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany

Re:RE: Query Optimization

2002-07-25 Thread Oliver Six
t; >Has anyone else tried writing a query similar to this? Does anybody have >any suggestions? > >Thanks in advance, > >Dave > Hi Dave, IMHO you can speed up your queries if you convert your columns to (unsigned) int if possible. It should be much faster to compare two integers

Re:myODBC BIGINT conversion

2002-07-18 Thread Oliver Six
ver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42 --

Re:UPDATE command..

2002-07-16 Thread Oliver Six
x27;domain2') WHERE domain='domain1. com'; Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42

Re:Numeric Type Inconsistency ?Bug

2002-07-12 Thread Oliver Six
's reproducible. The problem appears if the upper range exceeds 0.92233e19 (signed bigint). But the manual states that this is NOT a bug: expr BETWEEN min AND max ... - If expr is an integer expression, an integer comparision is done. - Otherwise, a floating-point (real) comparision is d

Re:help !

2002-07-10 Thread Oliver Six
etwork connection. Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42 -

Re:rand() ... limit by .... & my retrivals

2002-07-09 Thread Oliver Six
t; echo ( $tName ); > > } // echo (""); > > echo(""); > > >problem: >it only displays firstName n nothing else though 5 random first names >but >i guess i'll ve to make seperate query fo each field in the

Re:Re: Licensing--web site is schizophrenic

2002-07-08 Thread Oliver Six
whenever I write a program in msc which makes use of the libmysql.dll in conjunction with MySQL 4.x I have to make this program GPL? Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, G

Re:Re: Re:Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine

2002-07-08 Thread Oliver Six
oblem still exists, system working, so i don't >know, it is dangerous sytuation ? > >regards, > >Irek. > > >- Original Message - >From: "Oliver Six" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED

Re:Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine

2002-07-08 Thread Oliver Six
s usual (no zombie). > > Regards > Irek. > Hi Irek, do you have something in the logs (i.e. /var/lib/mysql/.log) when this happens? Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbern