Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re: Re: (OT) MySQL select Question

by Beatnik (Parson)
on Jul 26, 2003 at 22:31 UTC ( #278146=note: print w/ replies, xml ) Need Help??


in reply to Re: (OT) MySQL select Question
in thread (OT) MySQL select Question

mysql doesn't do subqueries yet... You better do 2 selects and insert the data from the first into the second one.

Greetz
Beatnik
... I'm belgian but I don't play one on TV.


Comment on Re: Re: (OT) MySQL select Question
Re: Re: Re: (OT) MySQL select Question
by antirice (Priest) on Jul 26, 2003 at 22:36 UTC

    Umm... I know MySQL doesn't do subselects. In the selection I posted, there aren't any subselections. The module of which I was speaking was so you could actually use SQL-92 style subselections but have them translated into multiple queries which, yes, do create temporary tables. For this particular query, however, there is no need to create a second table.

    Updated: Seemed a bit harsh. Just having a bad day :-/

    antirice    
    The first rule of Perl club is - use Perl
    The
    ith rule of Perl club is - follow rule i - 1 for i > 1

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://278146]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (7)
As of 2015-07-04 02:04 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (57 votes), past polls