Hi Steven, Just one UNLOCK TABLES. :-) From http://www.mysql.com/doc/en/LOCK_TABLES.html
"LOCK TABLES locks tables for the current thread. UNLOCK TABLES releases any locks held by the current thread. All tables that are locked by the current thread are implicitly unlocked when the thread issues another LOCK TABLES, or when the connection to the server is closed." BTW, you can't do INSERTs when the table(s) are locked with a READ lock. ;-) Need a WRITE lock for that. Hope that helps. Matt ----- Original Message ----- From: "Steven Wu" Sent: Friday, September 05, 2003 4:57 PM Subject: question about lock tables and unlock table > Hi Need some help here: > > if I have two tables, alertLog, videoLog needed to lock during some > processing as: > > mysql> LOCK TABLE alertLog READ, videoLog READ > > after two tables are lock and do some INSERT, > > mysql> INSERT INTO alertLog(alert); > mysql> INSERT INTO videoLog(video); > > > My question is DO I NEED ONE OR TWO "UNLOCK TABLES" to > release the locking ? so > > Is the answer ? > mysql>UNLOCK TABLES > mysql>UNLOCK TABLES > > or just > > mysql>UNLOCK TABLES > > > thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
