format_statement
Syntax
sys.format_statement(statement)
Description
Returns a reduced length string. The length is specified by the statement_truncate_len configuration option (default 64), and the removed part of the string (if any) is replaced with an ellipsis (three dots).
The function is intended for use in formatting lengthy SQL statements to a fixed length.
Examples
Default truncation length 64:
SELECT sys.format_statement( 'SELECT field1, field2, field3, field4, field5, field6 FROM table1' ) AS formatted_statement; +-------------------------------------------------------------------+ | formatted_statement | +-------------------------------------------------------------------+ | SELECT field1, field2, field3, ... d4, field5, field6 FROM table1 | +-------------------------------------------------------------------+
Reducing the truncation length to 48:
SET @sys.statement_truncate_len = 48; SELECT sys.format_statement( 'SELECT field1, field2, field3, field4, field5, field6 FROM table1' ) AS formatted_statement; +---------------------------------------------------+ | formatted_statement | +---------------------------------------------------+ | SELECT field1, field2, ... d5, field6 FROM table1 | +---------------------------------------------------+
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.