Nathan Coast wrote:
Hi
apologies if this is a dumb question but can you do subqueries in mysql?
select count(*) as RES from ACL_USER_GROUP_ROLE as UGR where UGR.USER_ID
=2 and UGR.ROLE_ID = (select ROLE_ID from ACL_ROLE where ROLE_NAME =
'projectmanager' )
this query fails, but the
Hi Nathan,
Subqueries are only available in MySQL as of version 4.1.
On Fri, 29 Oct 2004, Nathan Coast wrote:
Hi
apologies if this is a dumb question but can you do subqueries in mysql?
select count(*) as RES from ACL_USER_GROUP_ROLE as UGR where UGR.USER_ID
=2 and UGR.ROLE_ID = (select
- Original Message -
From: electroteque [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 28, 2004 6:33 PM
Subject: Sub queries
Hi there, I have Mysql 4.1 on my development machine, I have been
trying to test out if I am going to be able to do this. What I would
like
electroteque wrote:
Also I am trying to push for 4.1 to be installed on the servers i
build web apps on. When will be a possible date to say that gamma
which is practically production quality, to actually say production
quality ? heheh. Our systems guy will only trust it if it says that,
god
The keyword UNION should ensure that all duplicate rows are removed
from the combined result set. If you use UNION ALL instead of UNION,
the duplicates are left in the result set.
Yeh right, funny, early versions of 4.0, UNION had in the docs this was
only avail in 4.1, i am so sure i read
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 28, 2004 9:26 PM
Subject: Re: Sub queries
The keyword UNION should ensure that all duplicate rows are removed
from the combined result set. If you use UNION ALL instead of UNION
There are obviously many possible variations of your query; I just
stated one that was pretty close to your original query. It's really
not clear to me yet what you were trying to do so I just wanted to show
you typical syntax.
Ok sorry ppl I should have given a typical example in my
James Raff wrote:
I have MYSQL 3.23.32 on a Cobalt 550 platform. I see from the FAQ's that sub
That's a *very* old version. The latest 3.23 is 3.23.58. The current
production release is 4.0.20. You should consider upgrading.
queries will not work on MYSQL 4.1. Is there a way to use JOIN
* Jasper Bijl
Is there a way to do something like subqueries in one query?
Yes, JOIN can be used in many cases where you would think you need
sub-queries. A JOIN is also generally faster, according to:
URL: http://www.mysql.com/doc/en/ANSI_diff_Subqueries.html
I have a customer table (Klant)
PROTECTED]
Sent: woensdag 13 augustus 2003 13:40
To: [EMAIL PROTECTED]
Cc: Jasper Bijl
Subject: Re: sub queries in mysql?
* Jasper Bijl
Is there a way to do something like subqueries in one query?
Yes, JOIN can be used in many cases where you would think you
need sub-queries. A JOIN
Hello.
On Fri 2002-06-07 at 05:15:51 +0200, [EMAIL PROTECTED] wrote:
[...]
No, it's probably not difficult at all. It simply seems as if
people do not understand exactly what you want. A communication
problem, IMHO.
Kevin was also kind enough to point this out to me, and I have to
I'm sorry to disappoint you, but subqueries are NOT supported int any MySQL
version, yet.
You can read the MySQL manual about it. You can find there when and how it
will be implemented.
Bye
Daniel
At 21:39 2002.06.06. +0200, you wrote:
Lo all,
are sub-queries supported on mysql-max
Dániel [EMAIL PROTECTED]
To: Chris Knipe [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, June 06, 2002 9:47 PM
Subject: Re: sub-queries
I'm sorry to disappoint you, but subqueries are NOT supported int any
MySQL
version, yet.
You can read the MySQL manual about it. You can find there when
SELECT monitorhosts.HostID
FROM monitorhosts, monitorhostgroupdetails
WHERE monitorhosts.HostID = monitorhostgroupdetails.HostID
AND monitorhostgroupdetails.HostGroupID != '1');
Gruss
Sabine
Chris Knipe wrote:
Lo all,
are sub-queries supported on mysql-max 3.23.49 ??
If they are,
-
From: Chris Knipe [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 2:52 PM
To: [EMAIL PROTECTED]
Subject: Re: sub-queries
Fair enough (and also what I thought)
Does anyone have any idea how I can implement the below in a similar
fashion then?
I have a list of items, and a list
Subject: Re: sub-queries
SELECT monitorhosts.HostID
FROM monitorhosts, monitorhostgroupdetails
WHERE monitorhosts.HostID = monitorhostgroupdetails.HostID
AND monitorhostgroupdetails.HostGroupID != '1');
Gruss
Sabine
Chris Knipe wrote:
Lo all,
are sub-queries supported on mysql-max
to have to use PHP arrays and compare
arrays with hundreds of thousands of values in them?? *deep sigh*
- Original Message -
From: Chris Knipe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 06, 2002 10:16 PM
Subject: Re: sub-queries
*MWAH*!!!
Thanks a million
:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 1:52 PM
To: [EMAIL PROTECTED]
Subject: Re: sub-queries
Ok, I spoke to soon... And this is starting to drive me up
the walls now...
i.e. getting REALLY irritating and frustrating.
mysql DESCRIBE monitorhosts
- Original Message -
From: Kevin Fries [EMAIL PROTECTED]
To: 'Chris Knipe' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, June 07, 2002 12:38 AM
Subject: RE: sub-queries
Chris,
sounds like you're looking for an exclusive left outer join.
You want to see records from
Hi.
On Fri 2002-06-07 at 01:55:18 +0200, [EMAIL PROTECTED] wrote:
[...]
Chris,
sounds like you're looking for an exclusive left outer join.
You want to see records from monitorhosts, where there is no corresponding
record
in monitorhostgroupdetails, right?
Yes - and no. If a
All sorted, thanks a million to Kevin Fries
For archives purpose and anyone else that ever want to do anything like
this... The query I was looking for apparently (Tested and working so far -
I will test it a bit more later when I have more data in the tables):
select monitorhosts.HostID,
Sorry, I was away for a bit, and got side tracked!
I have a tiered Access application running over a WAN, and performance has turned out
to be an issue. But to convert the Access queries into something that MySQL can
understand takes a while. I started converting them before, but ran into a
Hi.
On Thu, Jan 18, 2001 at 03:25:24PM -0500, [EMAIL PROTECTED] wrote:
Sorry, I was away for a bit, and got side tracked!
I have a tiered Access application running over a WAN, and
performance has turned out to be an issue. But to convert the
Access queries into something that MySQL can
You can get around subqueries by using JOIN's. mySQL may not have all the
bells and whistles that some
other db applications may have, but more often than not, there is a way to
get around it.
Paul DuBois covers this in his mySQL book very well.
-Original Message-
From: Mark Marshall
24 matches
Mail list logo