Is it possible to update a table in one database with data from a table in another database?

If possible, please provide an example
September 26th 19 at 06:42
1 answer
September 26th 19 at 06:44
Solution
Maybe if DB on same server.

REPLACE INTO 'db1'.'table_1' ( a,b,c ) SELECT a,b,c FROM 'db2'.'table_2' WHERE ....
And what about database connectivity? - willy_Reynol commented on September 26th 19 at 06:47
Database on one server, but connect via different users - willy_Reynol commented on September 26th 19 at 06:50
Not to be the bases should be available for the current connected user. Differently and there is no other way. - Gideon_Bartoletti commented on September 26th 19 at 06:53
Thank you! - willy_Reynol commented on September 26th 19 at 06:56

Find more questions by tags MySQL