# Limitations Of Prepared Statements
+ You cannot nest prepared statements
  + The statement to be prepared must not contain PREPARE, EXECUTE, and DEALLOCATE 
+ You can only prepare a single statement instead of multiple statements
+ You cannot prepare a statement that contains a dynamic cursor declaration
  + This is because TiDB checks the cursor syntax/statement within the prepared statement when creating the cursor

------------------------------------------------------------
TiDB does not allow you to prepare every type of SQL statement.

You cannot nest prepared statements。

You cannot prepare multiple statements, by single prepare.

You cannot prepare a statement that contains a dynamic cursor declaration. This is because TiDB checks the cursor syntax when use prepare, which in turn means your prepared statement can only prepare static cursor.

You cannot prepare diagnostic statements as required by the SQL standard. Diagnostic statements include: 

SHOW ERRORS/WARNINGS

For a full list of SQL statements allowed in prepared statements, see: https://dev.mysql.com/doc/mysql/en/sql-syntax-prepared-statements.html.