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 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] > -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 4 days, processed 189,881,535 queries (440/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]