rollback not working in mysql

Question

i have user table, i have 5 records ,

i delete two records , then executed the rollback command, rollback command executed successfully.

But that deleted two records not recovered ,

user table engine is innodb...

Answer 1

By default, MySQL starts the session for each new connection with autocommit enabled,

You could set autocommit mode disable before running your query

SET autocommit=0;

ref:

1. http://dev.mysql.com/doc/refman/5.0/en/innodb-transaction-model.html
2. http://dev.mysql.com/doc/refman/5.0/en/innodb-transactions-with-different-apis.html

Answer 2

make sure you already do command start transaction;

before query delete

cmiiw

Answer 3

SET autocommit=0;
BEGIN;
.
.
.
ROLLBACK;

http://dev.mysql.com/doc/refman/5.0/en/commit.html