MYSQL: Is there an SQL var to say I've Started a Transaction (InnoDB)?

[jezzer300]

The trouble is that if you some how START TRANSACTION twice, the second one does a COMMIT. (Which is very silly, it should error IMO).

Anyhow is there a varaible I can SELECT which will tell me if a TRANSACTION has already been started?

Regards,

Jez.

PHP5 / MySQL InnoDB

[arran]

Hi jezzer,

InnoDB doesn't support nested transactions, however, savepoints [dev.mysql.com] may help you.

arran.

[jezzer300]

thanks.

It was more the worry of a subroutine accidentially doing a start transaciton without causing any error!. Scary.