Hi,

I wonder is it possible to do an insert to >1 table where each table is in a separate database?

Code MySQL:
insert into db1.table AND db2.table
    VALUES( ?, ?, ?, ? )
    WHERE 1

I am trying to plan how to make a test db and a live db each have the same values so that I can test my scripts in a dummy environment and so, not break my live db.

If not possible then I suppose I need to look into some method of database syncronisation or something.

bazz