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 = (se
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 individua
>>
> 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 i
- 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
>>
> 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
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 on
- 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
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 stat
und [mailto:[EMAIL 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
* 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:
http://www.mysql.com/doc/en/ANSI_diff_Subqueries.html >
> I have a customer table (Klant) wi
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 t
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, monito
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 - an
- 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 looki
: Chris Knipe [mailto:[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
s NOT allready in that specific group.
Is this possible, or am I really going 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]>
AIL PROTECTED]>
Sent: Thursday, June 06, 2002 10:14 PM
Subject: Re: sub-queries
> SELECT monitorhosts.HostID
> FROM monitorhosts, monitorhostgroupdetails
> WHERE monitorhosts.HostID = monitorhostgroupdetails.HostID
> AND monitorhostgroupdetails.HostGroupID != '1');
>
al Message-
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
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: "Kiss 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
> vers
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-ma
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 c
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 s
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 [
What's your subquery and we can help you convert it to a join.
On 16 Jan 2001 15:59:48 -0500, Mark Marshall wrote:
> Hi all,
>
> Is there any kind of schedule that says when the next MySQL version will be
>available? I'd like to utilize MySQL here, but I can't really start to seriously
>work
25 matches
Mail list logo