Commit <--> Rollback

[Anon]

Please tell me is there any place in the net where I can find an example php code of using the commit and rollback functions of MySQL.

Thank you

[toma42]

mysql.com/manual

[Anon]

OK if I do:
UPDATE groups SET name='qqqqqqqqq' WHERE id=1;

What shal I do to ROLLBACK this change

I tried with just
ROLLBACK;

But nothing happend

Please advise - in the manual it is not very clear...

[toma42]

you must begin a transaction block in ANY sql database with

begin transaction;