Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2004071

Re: [PHP-DB] Table locking From: John W. Holmes (holmes072000 <email protected>)
Date: 07/10/04

Rosen wrote:
> 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 ).

You could try a multi insert syntax such as

INSERT INTO yourtable (a,b,c) VALUES (1,2,3),(4,5,6),(7,8,9);

which will insert three rows into the table. Couldn't confirm in the
manual, but this INSERT should run completely before anything else does.

I still have to question _why_ another INSERT in the middle of your
insertion will mess things up. Sounds like the problem is there.

> Is there a problem with locking if PHP uses same user&pass for all users in
> database ?

No. The LOCK is on a per connection basis and is not tied to the
username and/or password. 

-- 
---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