Re: Lock table

Hello Mark, On 05-Aug-00 07:19:10, you wrote: > Is there any methods to lock the table from prevent updating and > deleting. Does such syntax exists ?? Using PHP + MySQL. Yes, LOCK TABLE, but beware of inadvertdly forgot UNLOCKs , especially if you are using persistent connections running PHP as Web server module, as you may lock all other processes from accessing that table until the Web server processes from which the lock was made ends. You may want to use register_shutdown_function() to make sure that doesn't happen and eventually warn yourself of a bug in your scripts. Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org -- E-mail: mlemos@acm.org URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --