Re: Re[2]: counting rows ...

2002-06-19 Thread Michael Widenius
Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Victoria Reznichenko writes: >> Hi! >> SM> Are you using our binaries ?? >> >> Yes. >> SM> If yes, send me a dump of the table and exact queries ... >> >> It's a strange... >> >> Seems, troubles occur when there i

Re: MySQL stability on OS X

2002-06-19 Thread Marc Liyanage
Hi all, >> I faced a similar problem, as have a few other people on the >> list, it seems. >> On the recommendation of another Mac OS X MySQL user (the >> extremely helpful >> Tony Niesz), I compiled my own MySQL server (rather than using >> the one Apple >> distributes or the binary Marc Liy

Re: Don't even know where to start on this one

2002-06-19 Thread Dr. Frank Ullrich
Chris, look at your queries, EXPLAIN your queries! SHOW PROCESSLIST during peak mysql activities. 15 connections? Sometimes you can bring a server down by means of a single bad SQL statement! Regards, Frank. Chris Knipe wrote: > > Lo all, > > I don't know if this can be reproduced,

Re: INSERT to table from text file

2002-06-19 Thread Eivind A. Sivertsen
> I have a server (any server, could be a RADIUS, a DNS or a MTA) that > logs to a file in "/var/logs/log-file". Is there a way to take the raw > data sent to the log file and "INSERT" it into a table? Can this be > done on the "fly", meaning, the data isn't stored in the flat text file > at all

RE: mysql and unicode ....

2002-06-19 Thread Dean Harding
Not natively (i.e. you can't sort on a Unicode field, for example), but you can still store Unicode text in fields. Just use a BLOB or you can even use VARCHAR(), et al, but remember that you only get half as many Unicode characters as you specify in the field width... If you're using the native

LibMySQL.DLL?

2002-06-19 Thread RBRoa
Hi to all, Where can I find the stable LIBMYSQL.DLL?... Im just confuse which one to usei found the file in LIB\DEBUG and LIB\OPT...they are not equal in size... Thanks... R.B.Roa Traffic Management Engineer PhilCom Corporation Tel. No.(Office) (088) 858-1028 (Home) (088) 858-888

Re: Mysql SELECT IF()

2002-06-19 Thread Paul B van den Berg
On 18 Jun 2002 at 16:36, Walter D. Funk wrote: > Hi everybody! > > I need to count the ACTIVE users of my Mysql users table; where 'active' is > a flag showing this status, > using the following query it returns all the user in the table, and I need > only those who have tha flag active set to '