Transaction ID in MySQL Trigger

Question

Is there a way to retrieve a transaction ID inside a MySQL trigger?

Answer 1

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.

Answer 2

But how can we get sql statement for this connectionid?

like for sql server we can get from dbcc inputbuffer(@@spid)

How can it with Mysql?