Question: I have a user table, and I have 5 records.

I deleted two records, then executed the rollback command, it executed successfully.

But that deleted two records not recovered.

The user table engine is [InnoDB](http://en.wikipedia.org/wiki/InnoDB).

Answer: 
```
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: 

**[Link 1](http://dev.mysql.com/doc/refman/5.0/en/innodb-transaction-model.html)**

**[Link 2](http://dev.mysql.com/doc/refman/5.0/en/innodb-transactions-with-different-apis.html)**
If you're using MySQL Workbench you can turn off Auto-commit transactions in 'Query' tab.
And don't forget to use "COMMIT;" after the Query which you need to rollback.