Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re: help deriving mysql query from perl script

by tospo (Hermit)
on Jul 30, 2012 at 08:44 UTC ( #984395=note: print w/ replies, xml ) Need Help??


in reply to help deriving mysql query from perl script

Hmmm, the bad news is: if you don't know any Perl or SQL then I think you will really struggle to get this done - sorry for being a bit brutal here....

Anyway, since this seems to be for a good cause, I think you can get some support here for sure but it may require a bit of work.

So, first of all: when you run this in a browser, can you give us the exact "where clause" and "group clause" you enter into the web form? There are two statements for queries to run against the database in that script and they both take these free-form chunks of SQL code. Since you say yourself that you don't know SQ, my suspicion would be that you entered SQL chunks that don't do what you think they are doing and that the DB is choking on a large amount of data to process.

To get tot he bottom of all this, you need to familiarise yourself with a tool for interacting with your database directly, i.e. someting to run queries against the DB and see the outcome. I would use the MySQL shell in a terminal and I also use this one here quite a bit if I want a GUI and graphical output: DbVisualizer - there is a free version that does all you need to do.
There are of course plenty of other tools to choose from.


Comment on Re: help deriving mysql query from perl script

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (5)
As of 2014-09-03 03:51 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite cookbook is:










    Results (35 votes), past polls