Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2004071

Re: [PHP-DB] Table locking From: Rosen (rosen <email protected>)
Date: 07/10/04

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 <email protected>> wrote in message
news:40EDE440.9050100 <email protected>
> 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 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php