MySQL can't roll back as expected....

[sleepy wang]

Working on the MySQL server 5.0.18. And writing a batch SQL file with a transaction as below:


use mydb;

delimiter //
SET autocommit=0;

start transaction;

update test set name='another';

rollback;
show warnings ;
select * from test;

delimiter ;

But warning code "1196" is printed when the rollback is called and the table data is updated without rollback.

Is it the right way to use MySQL transaction? or is there any other configuration i need to take care?

Thx in adv.