Re: Table locking

I need to be sure, thath nobody else will can write on some tables until I don't append obout 4-500 records in these tables. But until now I never used table locking in MySQL and I didn't found information about this ( like examples ). Is there a problem with locking if PHP uses same user&pass for all users in database ? Thanks in advance ! Rosen "John W. Holmes" <holmes072000@charter.net> wrote in message news:40EDE440.9050100@charter.net... > Rosen wrote: > > > And if I perform "LOCK tables ..." nobody can;t write on these tables, > > until I don't perform "UNLOCK TABLES" ? > > If something happens ( I mean if some my queryes fails) ? > > I have a feeling it would be very very good if you'd state why you feel > you need to LOCK these tables. There are generally a couple ways to do > things, so you may not need to worry about locking at all. > > -- > ---John Holmes... > > Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ > > php|architect: The Magazine for PHP Professionals – www.phparch.com