Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
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 2015-07-05 10:17 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 (61 votes), past polls