[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:[EMAIL PROTECTED] Sent: Wednesday, January 23, 2008 11:29 AM To: Brown, Charles; mysql@lists.mysql.com 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
