Mysql - Copying Info to another database??
Posted on 2006-06-20
I have got a scheduled task in place that moves information from 1 database (Firebird) to another (MySQL). The issue that i have, is that some information that goes into the MySQL database, also needs to be in ANOTEHR MySQL database, which is stored on the same server.
Rather than modifying the scheduled task to do 2 updates, is it possible to create a trigger, that would move selected data into the other database.
E.g. If account = "041" then copy field A, B, C, D into the other database
Is this possible?
Thanks very much
PS - high point score as it would be very valuable to me