I wonder is it possible to do an insert to >1 table where each table is in a separate database?
insert into db1.table AND db2.table
VALUES( ?, ?, ?, ? )
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.