Re: Re: lock table problems

hi, You mean if I have 10 tables under the same database, once I locked one table with the statement "lock tables table1 read", then the other tables(the rest of table except table1) will not be allowed to access by me or other people, even for reading......unless I unlock table1. Is that what you mean.?? Thank you Mark ----- Original Message ----- From: Gerald L. Clark <gerald_clark@suppliersystems.com> To: Mark Lo <markloky@netvigator.com> Cc: php general <php-general@lists.php.net>; <mysql@lists.mysql.com> Sent: Wednesday, August 09, 2000 5:06 AM Subject: [PHP] Re: lock table problems > Mark Lo wrote: > > > > Hi, > > > > when I exec the script like mysql_query("lock tables table_name read"); > > this script locks all of the tables under the same database. Can anyone point me out please!!! > > > > Thank You so much > > > > Mark > No it does not. > It only locks the tables you tell it to lock. > You can only access tables you locked until you unlock the tables. > This prevents deadlocks. > If you intend to access table2 while table1 is locked, you must lock > them both > "lock tables table1 read, table2 read" > > Please read the manual! > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >