#begin不会立即分配TRX_ID
begin;
#触发分配TRX_ID
select * from t;
#指定TRX_MYSQL_THREAD_ID=当前CONNECTION_ID,表示查询当前连接
select TRX_ID from INFORMATION_SCHEMA.INNODB_TRX where TRX_MYSQL_THREAD_ID = CONNECTION_ID();
commit;
MySQL查询当前事务ID TRX_ID
最新推荐文章于 2024-08-12 20:26:38 发布