Re: Is this an inefficient query?

2003-06-03 Thread Giorgos Gaganis
Jay Blanchard wrote: [snip] $qin = SELECT COUNT(cdr.ani) AS qtyin, SUM(cdr.calldur/60) AS minin ; $qin .= FROM tblCDR cdr LEFT OUTER JOIN CDRFilter e ; $qin .= ON cdr.dialedno = e.phoneNumber ; $qin .= WHERE e.phoneNumber IS NULL ; $qin .= AND (cdr.dialedno LIKE '800%' ; $qin .= OR cdr.dialedno

4.1 Self Compiled Problems

2003-02-13 Thread Giorgos Gaganis
Hello I have downloaded 4.1 source and successfully compiled it. When i use the mysql client as a root it works without problems. If i use the client as a different user when i try to use the 'use DATABASE' command i get a segmentation fault. Here is a backtrace of the stack when the program

Re: # of connected user

2003-02-01 Thread Giorgos Gaganis
try using the command: mysqladmin -v processlist Gaganis Mustafa Yelmer wrote: How i list connected users(active) to mysql server? it is important to know connected users for me? Mysql runs in server-client system, and each host of clients are different (i assume) Mustafa Yelmer Software