List:General Discussion« Previous MessageNext Message »
From:Jay Blanchard Date:January 23 2008 5:28pm
Subject:RE: executing query from the command line -- need help
View as plain text  
[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
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