Retro Eye care Haitian Deep Dark Default

FORMAT SQL

Description

The FORMAT SQL syntax is used to parse SQL and output formated SQL statement.

Syntax

ParseSql ::=
  'FORMAT' sqlStatement  

Return Value Description

Column Description
formatted_result formated SQL statement

Example

  • Parse SQL and output formated SQL statement
FORMAT SELECT * FROM t_order;
mysql> FORMAT SELECT * FROM t_order;
+-------------------------+
| formatted_result        |
+-------------------------+
| SELECT *
FROM t_order; |
+-------------------------+
1 row in set (0.00 sec)

Reserved word

FORMAT