From: obed (obed.listasgmail.com)
Date: Wed Jan 23 2008 - 22:49:08 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On Jan 23, 2008 2:36 PM, Jay Blanchard <jblanchardpocket.com> 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:jblanchardpocket.com]
> Sent: Wednesday, January 23, 2008 11:29 AM
> To: Brown, Charles; mysqllists.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/mysql?unsub=obed.listasgmail.com
>
>

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]