help query analysis

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

Re: Help query with MySQL 4.0.11

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 http://www.mysql.com/doc/

Re: Help query with MySQL 4.0.11

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 http://www.mysql.com/doc/en/Nutshell_4

Help query with MySQL 4.0.11

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 suggestion needed - interesting case

>>return just the first time row per each event_id. >> >>Thanks anyway. I may have to use second query... :-( >> >> >>Mihail >> >> >>- Original Message - >>From: "Bhavin Vyas" <[EMAIL PROTECTED]> >>To: &q

Re: Help - query suggestion needed - interesting case

cond 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 - qu

Re: Help - query suggestion needed - interesting case

first time row per each event_id. > >Thanks anyway. I may have to use second query... :-( > > >Mihail > > >- Original Message - >From: "Bhavin Vyas" <[EMAIL PROTECTED]> >To: "Mihail Manolov" <[EMAIL PROTECTED]>; <[EMAIL PROTECTE

Re: Help - query suggestion needed - interesting case

ROTECTED]> 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 Ran

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 - Original Message - From: "Mihail Manolov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 11, 2002 2:58

Help - query suggestion needed - interesting case

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 quer

help: query

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'