Transaction in MySQL Shell — Python mode with examples

Although my day job has lately been filled primarily with MySQL and PHP development — which I absolutely enjoy — I still make spare time for MySQL and Python hacking; particularly in the MySQL Shell. For whatever reason, I am drawn back to this specific environment. SAVEPOINT, COMMIT, and START TRANSACTION are integral commands for working within a database transaction. MySQL Shell fully supports these commands. We can even execute them in Python mode! Continue reading to see them in action…