START TRANSACTION COMMIT ROLLBACK

[Mosaed AlZamil]

Hello Everyone,
 I am a newbie using innodb.
How can I implement  START TRANSACTION COMMIT ROLLBACK when I need to update
two tables
that are located in two different databases. Would a single  START
TRANSACTION be sufficient ?
Any help would be appreciated.
TIA
Mos