MySQL Transactions and User-defined session variables.

Have a look at the updated and improved session_var.sql file now: And when running the session_var.sql file in batch mode: mysql> source /home/myUser/myFolder/session_var.sql Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 Query OK, 2 rows affected (0.00 sec) Rows matched: 2 Changed: 2 Warnings: 0 Query OK, 0 rows affected (0.02 sec) mysql> All updates are successful.