Revision history [back]

Yes, it is possible to use an AFTER DELETE TRIGGER to automatically remove two rows from two separate tables when a user deletes a row from a third table within three different databases located on the same mySQL server. However, the syntax and implementation of the trigger will be slightly different compared to when working with a single database. You will need to use fully qualified table names to reference the tables in different databases and make sure that the appropriate permissions are set for the trigger to work across multiple databases.