rollback works on myisam ? this is mysql4 anyway, sweet i'll give it a try.
Rollback *doesn't* work with MyISAM, that's why Jeremy said you have to put the necessary logic in your application if you want to achieve the same effect.
At least, that's what I think he said. :-)
On Fri, 2003-09-19 at 08:01, Jeremy Zawodny wrote:> JeremyOn Thu, Sep 18, 2003 at 03:00:17PM +1000, [EMAIL PROTECTED] wrote: > Hi there i have a couple of projects which required fulltext searching so > was unable to setup innodb on these. I was wondering if lock tables is a > secure way to make the transaction on these tables and does this prevent > being read upon aswell?
Obtaining a WRITE lock on a MyISAM table prevents readers, yes.
But you do have to put the necessary smarts into your code to properly implement a ROLLBACK if you need one.
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
