List Of MySQL Restrictions and Limitations

1. limitations on Stored Programs The following additional limitations apply for stored programs: Some of the limitations mentioned here apply to stored procedures and stored functions. SQL Statements Not allowed in Stored Routines Stored routines can’t contain arbitrary SQL statements. The following statements are not allowed: The locking statements LOCK TABLES and UNLOCK TABLES. ALTER … Read more