mysql cli transaction management feature across sessions
We are running the SQL scripts (with DML queries) using mysql cli as specified below,
mysql -vv -u${username} -p${password} -h${host} -P3306 --ssl-mode=DISABLED ${databasename} < script/lc-script.sql
We used the transaction management functionality using transaction commands like this
START TRANSACTION;
SET autocommit=0;
//DML QUERY;
//DML QUERY;
//.
//.
//.
COMMIT; // OR ROLLBACK;
But once we close the mysql session we loose the transaction. We want to start the transaction in one session and then commit or rollback it in the another session.
Is there any way by which we can enable the transaction management functionality across sessions?
Subject
Written By
Posted
mysql cli transaction management feature across sessions
April 05, 2023 02:16AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.