List:General Discussion« Previous MessageNext Message »
From:Jay Blanchard Date:January 23 2008 8:36pm
Subject:RE: executing query from the command line -- need help
View as plain text  
[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.
Thread
Did NOT condition on VARCHAR change with 5.0.45?Mont McAdam15 Jan
  • Re: Did NOT condition on VARCHAR change with 5.0.45?Martijn Tonies15 Jan
    • Re: Did NOT condition on VARCHAR change with 5.0.45?Moon's Father16 Jan
Re: Did NOT condition on VARCHAR change with 5.0.45?Mont McAdam23 Jan
  • RE: Did NOT condition on VARCHAR change with 5.0.45?Jerry Schwartz23 Jan
  • Re: Did NOT condition on VARCHAR change with 5.0.45?Perrin Harkins23 Jan
    • executing query from the command line -- need help Charles Brown23 Jan
      • RE: executing query from the command line -- need help Jay Blanchard23 Jan
      • RE: executing query from the command line -- need help Jay Blanchard23 Jan
RE: executing query from the command line -- need help Jay Blanchard23 Jan
  • Re: executing query from the command line -- need helpobed24 Jan
    • RE: executing query from the command line -- need helpCharles Brown24 Jan