LOCKS???

[email protected] (Tedd Sperling)
Newsgroups php.general
Message-ID <[email protected]>
Hi gang:

I’ve read a bunch about MYSQL LOCKs, but I can seem to get them to work.

For example, I have two computers accessing the same host (i.e., thus each with different SIDs) and accessing two different scripts. One script performs a "LOCK TABLES t WRITE" and the second script tries to read TABLE t. While the LOCK is in place, the second script has no problem reading and writing to TABLE t.

I don’t understand what's wrong — any ideas?

Thanks,

tedd
_______________
tedd sperling
[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.