every statement is its own transaction. For any operation involving multiple related statements, you must disable auto-commit and manage transactions explicitly: