RE: executing query from the command line -- need help

[Jay Blanchard]

[snip]
Hello Jay. Thanks for your reply but where is your solution to my
problem. I'm lost here. Help me -- please 

Thx


-----Original Message-----
From: Jay Blanchard [mailto:jblanchard@stripped] 
Sent: Wednesday, January 23, 2008 11:29 AM
To: Brown, Charles; mysql@stripped
Subject: RE: executing query from the command line -- need help 

[snip]
SELECT SYS_ID, SYS_LOCATION, SYS_IP FROM PROD_SERVER;

UPDATE TEST_SERVER
SET SYS_ID  = &value passed from above
      SYS_LOCATION = &value passed from above
       SYS_IPADDRESS = &value passed from above; 

[/snip]

And here http://dev.mysql.com/doc/refman/5.1/en/user-variables.html
[/snip]

Always reply to all so that this goes back to the list. I found this in
my junk folder.

When you retrieve the value from the first query assign that value to a
variable which can then be used in the second query.