Hi, > I've a problem with transaction > I initiate a transaction with "start transaction". Soon i execute > following query: > * update t1 set t=12; and by I complete I execute rollback but when I do > it I obtain the following thing: > "non-transactional Some changed tables couldn't be rolled back" and > update I execute myself updating the data > Why do it? > I'm use MySQL 4.1.20 and MyISAM tables
Have you been reading any documentation on Transactions in MySQL? MyISAM tables don't support transactions! For each table, you can assign a different "storage engine", which is the implementation that physically stores your data. Depending on the storage engine you're using for your table, MySQL supports different features, like transactions. Read the docs on the different engines. Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
