rollback works on myisam ? this is mysql4 anyway, sweet i'll give it a try.
On Fri, 2003-09-19 at 08:01, Jeremy Zawodny wrote: > On 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. > > Jeremy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
