Skip to main content
Version: Candidate-4.0

get_query_dump

get_query_dump(query) get_query_dump(query, enable_mock)

These functions return a dump of the query for debugging purposes.

Arguments​

query: The SQL query string (VARCHAR). enable_mock: (Optional) A boolean value indicating whether to enable mock data for the dump. Defaults to FALSE.

Return Value​

Returns a VARCHAR string containing the query dump.

Examples​

Example 1: Get a simple query's dump without mocking data

mysql> select get_query_dump('select * from ss limit 1');
1 row in set (0.04 sec)