help query analysis

2004-07-26 Thread Jacob, Raymond A Jr
I am trying to analyze a query that is taking forever. I am new to this so or rather desperate. I would assume that my query would be faster, if the event id (*.cid) Primary key were used to search for rows in the iphdr table with the same event id, but I don't think that is happening. Could some

Help query with MySQL 4.0.11

2004-03-24 Thread WebMaster Informática007
Hi I have problem with a Query. It does not recognize EXISTS. My version is MySQL 4.0.11a-gamma The query is: SELECT U.usu_id, U.usu_login FROM cva_usuario U WHERE NOT EXISTS (SELECT * FROM cva_grupo_usuario GU WHERE GU.usu_id=U usu_id Where GU.gru_id=4) Help please.

Re: Help query with MySQL 4.0.11

2004-03-24 Thread Paul DuBois
At 21:44 -0400 3/24/04, WebMaster Informática007 wrote: Hi I have problem with a Query. It does not recognize EXISTS. My version is MySQL 4.0.11a-gamma Subqueries are supported beginning with MySQL 4.1.0. http://www.mysql.com/doc/en/Subqueries.html

Re: Help query with MySQL 4.0.11

2004-03-24 Thread Michael Stassen
Paul DuBois wrote: At 21:44 -0400 3/24/04, WebMaster Informática007 wrote: Hi I have problem with a Query. It does not recognize EXISTS. My version is MySQL 4.0.11a-gamma Subqueries are supported beginning with MySQL 4.1.0. http://www.mysql.com/doc/en/Subqueries.html

Re: Help - query suggestion needed - interesting case

2002-07-15 Thread Francisco Reinaldo
Message - From: Bhavin Vyas [EMAIL PROTECTED] To: Mihail Manolov [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 10:51 PM Subject: Re: Help - query suggestion needed - interesting case How about: SELECT event_id, time, count(DISTINCT time) AS Ranges

Re: Help - query suggestion needed - interesting case

2002-07-15 Thread Ralf Narozny
... :-( Mihail - Original Message - From: Bhavin Vyas [EMAIL PROTECTED] To: Mihail Manolov [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 10:51 PM Subject: Re: Help - query suggestion needed - interesting case How about: SELECT event_id, time, count(DISTINCT

Re: Help - query suggestion needed - interesting case

2002-07-12 Thread Mihail Manolov
] To: Mihail Manolov [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 10:51 PM Subject: Re: Help - query suggestion needed - interesting case How about: SELECT event_id, time, count(DISTINCT time) AS Ranges FROM events GROUP BY event_id HAVING Ranges 1

Re: Help - query suggestion needed - interesting case

2002-07-12 Thread Ralf Narozny
. Thanks anyway. I may have to use second query... :-( Mihail - Original Message - From: Bhavin Vyas [EMAIL PROTECTED] To: Mihail Manolov [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 10:51 PM Subject: Re: Help - query suggestion needed - interesting case How about

Help - query suggestion needed - interesting case

2002-07-11 Thread Mihail Manolov
Greetings, I am stuck with this problem: I have the following table: event_id time 1002000-10-23 1002000-10-23 1012000-10-24 1012000-10-25 I need to know all event_id's that have multiple times + time columns. Is it possible to get that result in just one

Re: Help - query suggestion needed - interesting case

2002-07-11 Thread Bhavin Vyas
How about: SELECT event_id, time, count(DISTINCT time) AS Ranges FROM events GROUP BY event_id HAVING Ranges 1 - Original Message - From: Mihail Manolov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 2:58 PM Subject: Help - query

help: query

2002-03-28 Thread Norman Zhang
Hi, I have setup a table with user login name and password. The password is encrypted with the MySQL's password(). How do I compare these info with the user's input. I had $query = select * from auth where usrname='$logname' and usrpass=password('$logpass'); mysql_query($query); But I can't