Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
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.

Replies are listed 'Best First'.
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?
[PriNet]: i think i found the problem, the "source" array that sets the individual key values isn't being cleared, it's keeping the previous values...
[atcroft]: PriNet: You might consider posting a small, self-contained snippet of that segment of your code, and see if someone else has a better idea.....
[atcroft]: PriNet: Ahhh... interesting.
[PriNet]: small would be a problem *heh*... the program reads all the lines from a pdf and converts the individual colum data to a seperate key/value pair... that's where the "previous" array from the pdf is not being cleared properly before reading the next pdf
[atcroft]: PriNet: It was a thought....
[PriNet]: thanx... actually just having someone to talk to was making me think... *heh*

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (4)
As of 2017-06-28 03:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many monitors do you use while coding?















    Results (620 votes). Check out past polls.