MySQL LOCK TABLES <table name> affects other tables if the thread originating
the function does not issue an "UNLOCK TABLES" call. Shouldn't it only
affect the table the lock is called on?
ie: If there is a script error before UNLOCK TABLES can be called, all
other calls to the DB will return an error indicating the table being
accessed was not locked with "LOCK TABLES".
This method is used instead of using transactions, as it is supposed to be
quicker with MyISAM tables.
the function does not issue an "UNLOCK TABLES" call. Shouldn't it only
affect the table the lock is called on?
ie: If there is a script error before UNLOCK TABLES can be called, all
other calls to the DB will return an error indicating the table being
accessed was not locked with "LOCK TABLES".
This method is used instead of using transactions, as it is supposed to be
quicker with MyISAM tables.