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 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 what I think he said. :-) > >> >>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 > > > -- > 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]