Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
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 chanting in the Monastery: (10)
As of 2014-10-23 10:14 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (125 votes), past polls