> 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
> r
On Thu, Sep 18, 2003 at 11:38:17AM +1000, electroteque wrote:
> rollback works on myisam ? this is mysql4 anyway, sweet i'll give it a
> try.
No. That's what I meant about having to put extra smarts in your code.
It needs to be able to undo its actions.
> On Fri, 2003-09-19 at 08:01, Jeremy Zawo
Righty, so if error unlock table hehe, i have found i need to produce my
error first then do a rollback for an error to display in php as it wouldnt
show a mysql error after a rollback, i guess i could add an unlock table in
my trigger error function too.
> At 11:38 AM +1000 9/18/03, electroteque
>
> No rollback does not work on myisam Jeremy was stating that you don't
> have to do what you suggested to implement a correct ROLLBACK in mySQL.
> Use INNODB.
>
> http://www.mysql.com/doc/en/COMMIT.html
>
>
Hmm if you got my other post i am trying to simulate innodb in myisiam for
projects tha
se 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 F
At 11:38 AM +1000 9/18/03, electroteque wrote:
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 wha
bject: Re: Lock tables in myisam
-->
-->rollback works on myisam ? this is mysql4 anyway, sweet i'll give it
a
-->try.
No rollback does not work on myisam Jeremy was stating that you don't
have to do what you suggested to implement a correct ROLLBACK in mySQL.
Use INNODB.
http://www.mysql.com/doc/en/COMMIT.html
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
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
> bein
