On Jan 23, 2008 2:36 PM, Jay Blanchard <[EMAIL PROTECTED]> wrote: > [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] > >
I'm going to propose you a horrible solution: mysql> select * from table1; +------+------+ | id | text | +------+------+ | 1 | one | | 2 | two | +------+------+ 2 rows in set (0.00 sec) mysql> select * from table2; +------+------+ | id | text | +------+------+ | 1 | one | +------+------+ 1 row in set (0.00 sec) mysql> update table2 set id=(select id from table1 where id=2), text=(select text from table1 where id=2) where id=1; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> select * from table2; +------+------+ | id | text | +------+------+ | 2 | two | +------+------+ 1 row in set (0.00 sec) Take care, greetings. -- http://www.obed.org.mx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
