Understanding Transactions in MySQL: A Comprehensive Guide to Atomic Operations in Databases