本文共 314 字，大约阅读时间需要 1 分钟。

SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX

MySQL 如何获得当前会话的TRX_ID 事务ID

SELECT TRX_ID FROM INFORMATION_SCHEMA.INNODB_TRX  WHERE TRX_MYSQL_THREAD_ID = CONNECTION_ID();

begin;select * from hbec_wallet_cg_fund_profit;SELECT TRX_ID FROM INFORMATION_SCHEMA.INNODB_TRX  WHERE TRX_MYSQL_THREAD_ID = CONNECTION_ID();commit;

转载地址：http://acnsi.baihongyu.com/