Hi,
As of our understanding, MySQL can show whether the engines support
Transactions and Savepoints. It does not list out the count or savepoints
that were not deleted.
But the solution for your query can be extracted from
shell> show engine innodb status\G
or
shell>show innodb status\G
and also
shell> show warnings\G [lists all the warnings, notes, messages of the
session]
Thanks
ViSolve DB Team.
----- Original Message -----
From: "vijay bahirji" <vijay_bahirji@stripped>
To: <mysql@stripped>
Sent: Monday, October 30, 2006 6:30 PM
Subject: how to retrieve a list of savepoint in mysql.
> hi all,I need some one to help me with this. I have put many savepoints
> during the transaction in mysql andI want to have the list of all the
> savepoints set during the current transaction.plz help.regards,Vijay
>
