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
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.
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
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
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
... :-(
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
]
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
.
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
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
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
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
11 matches
Mail list logo