Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://979372]
help
Chatterbox?
[rajesh_perl]: Hi
[rajesh_perl]: thanks for editing it
beech testing firefox 52.0.1
beech me me me me
beech mi
beech eieie
beech .oO( *you* don't exist, I'm only messaging to *me* self),
[beech]: *me

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (4)
As of 2017-03-28 07:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Should Pluto Get Its Planethood Back?



    Results (327 votes). Check out past polls.