I've never used a lock on a MySQL table so far, but need one now. Two questions:

1. Do I set the lock by a normal query, but in the form of "LOCK TABLE <tablename> WRITE", instead of "SELECT * FROM <tablename> WHERE x = 1"?

2. Can I set the lock in one query, then perform multiple other queries on the table, in between which I do some PHP work, and then release the lock several queries and lines of PHP code later?

anders thoresson

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

Reply via email to