It allows manual control of transaction boundaries.
Setting auto-commit to false lets you group multiple SQL statements into a transaction, which you can manually commit or rollback. This is essential for operations that must be atomic, like processing a batch of inventory updates in an e-commerce system.