nie sprawdzalem na nazwie ale to dziala
mysql> use stest;
mysql> create table a9 (i int);insert into a9 values(1);
Query OK, 0 rows affected (0.22 sec)
Query OK, 1 row affected (0.06 sec)
mysql> use test;
Database changed
mysql> create table a9 (i int);insert into a9 values(2);
Query OK, 0 rows affected (0.16 sec)
Query OK, 1 row affected (0.05 sec)
mysql> select * from a9;
+------+
| i |
+------+
| 2 |
+------+
1 row in set (0.02 sec)
mysql> select * from stest.a9;
+------+
| i |
+------+
| 1 |
+------+
1 row in set (0.00 sec)
mysql> update stest.a9,test.a9 set stest.a9.i=test.a9.i where test.a9.i=2;
Query OK, 1 row affected (0.06 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from stest.a9;
+------+
| i |
+------+
| 2 |
+------+
1 row in set (0.00 sec)
mysql> select * from a9;
+------+
| i |
+------+
| 2 |
+------+
1 row in set (0.00 sec)
mysql>