execute_prepared_stmt

Description

Takes the query in the argument and executes it using a prepared statement. The prepared statement is deallocated, so the procedure is mainly useful for executing one off dynamically created queries.

The sys_execute_prepared_stmt prepared statement name is used for the query and is required not to exist.

Parameters

in_query (longtext CHARACTER SET UTF8MB4): The query to execute.

Configuration Options

sys.debug Whether to provide debugging output. Default is ‘OFF’. Set to ‘ON’ to include.

Example

mysql> CALL sys.execute_prepared_stmt(‘SELECT * FROM sys.sys_config’); +————————+——-+———————+——–+ | variable | value | set_time | set_by | +————————+——-+———————+——–+ | statement_truncate_len | 64 | 2015-06-30 13:06:00 | NULL | +————————+——-+———————+——–+ 1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)