what is the rationale for not allowing LOCK TABLES in a stored procedure

<[email protected]> Mon, 13 Aug 2018 09:05:27 -0700

Newsgroups	gmane.comp.db.mysql.general
Message-ID	<20180813090527.b590a9905241a757901ccf2dc453f505.50df44ee80.wbe@email09.secureserver.net>

Hello, I have read through several pages of the reference manual, and
I've seen several instances where it is stated that LOCK TABLES (and
UNLOCK TABLES) is not allowed in a stored procedure, but so far, I
haven't found an explanation as to *why* that is. Could someone please
enlighten me?

Thanks



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql