mysql query browser can not perform rollback

[cuongvt]

:rolleyes: Hi all,
I'm newbie to mysql. I installed My sql query browser and I met a strange
problem with it as follow:
Supposes that I did as following:
- Begin
- insert into tablename values(1);
- rollback
- select * from tabkename

And the value 1 is shown in mysql query broswer. i think in this case, there must
be no value 1 in tablname table because I already performed "rollback".
Note: When I perform above actions in command promt, the value 1 is not shown
=> it is true.

Could anyone tell me what is strange problem and how can I fix it?
I don't like comand promt at all🙂
thanks

[bastien]

myisam (the default) table type does not support transactions...the sql won't fail but nothing will occur.

Should you need to use transactions, you need to use the INNODB table type

[cuongvt]

thank you