MySQL Forums
Forum List  »  General

mysql cli transaction management feature across sessions
Posted by: Onkar Kandalgaonkar
Date: April 05, 2023 02:16AM

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?

Options: ReplyQuote


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.