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

[Jay Blanchard]

[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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]