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)