Hi,

No, ROLLBACK doesn't work with MyISAM. Jeremy meant that you can add
logic/code between LOCK/UNLOCK to "simulate" ROLLBACK. e.g. queries that
"undo" what you did if something goes wrong. Of course this won't cover
you if mysqld dies, is killed, or you lose the connection etc. as real
transactions would.


Matt


----- Original Message -----
From: "electroteque"
Sent: Wednesday, September 17, 2003 8:38 PM
Subject: Re: Lock tables in myisam


> 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]

Reply via email to