Unanswered: How to track transactional state / nested transactions
I'm trying to construct something that should look like nested transactions within MySQL 5.0. To achieve this, I need to know at a certain location in a stored procedure, whether there is a transaction open, or not. Is there any way to check this ? I can't find it ... hope one of you can ...
> SELECT * FROM users WHERE clue > 0;
Empty set (0.00 sec)