Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re^2: Cross Table Mysql Update

by ig (Vicar)
on Jul 02, 2012 at 06:22 UTC ( #979372=note: print w/ replies, xml ) Need Help??


in reply to Re: Cross Table Mysql Update
in thread Cross Table Mysql Update

No doubt there are many ways to solve your problem. Others might like to see what your solution is.

What came to mind for me was not joins but sub-queries. This example from the MySql documentation might give you some ideas:

Here is an example of a subquery:

SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2);

In this example, SELECT * FROM t1 ... is the outer query (or outer statement), and (SELECT column1 FROM t2) is the subquery.


Comment on Re^2: Cross Table Mysql Update

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (8)
As of 2014-09-30 10:52 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (363 votes), past polls