How to update tables between two MySQL

Is there possible to link tables between two MySql databases???

if you're talking about redundant data, I've seen a perl script out there that will read the sql log and send those commands to a different server.

If you mean "can I select data from two different tables on two different databases" then yes, read the manual.

select * from database1.table1,database2.table4;

But I don't know how this would work if the databases were on different servers.

""""" ''"'"

vincent wrote:

If you mean "can I select data from two different tables on two different databases" then yes, read the manual.

select * from database1.table1,database2.table4;

But I don't know how this would work if the databases were on different servers.

Lauri,

What do you mean? Like selecting information from two tables? Updating two tables at once?

There is an article here on phpbuilder.com that will solve your problem.

It is by Joe Stump

Try that link....