Brian Fisher
Reputation: 23989
Transaction ID in MySQL Trigger
Is there a way to retrieve a transaction ID inside a MySQL trigger?
Upvotes: 5
Views: 1664
Answers (1)
Eric
Reputation: 95153
Currently, no. It's been an open request for four years. However, you can use connection_id() which will give the connection session, so you can group things by that.
Upvotes: 6
Related Questions
- Getting the current transaction ID with MySQL
- Are triggers transaction?
- Alter MySQL Trigger within Transaction
- Can I use transaction like capability in MySQL trigger
- MySQL transaction and trigger
- mysql trigger - how to add a record id after insert
- generate id number mysql
- MYSQL Update Trigger get updated row ID
- MySQL transaction and triggers
- MySQL: Invoke trigger after transaction is committed