How To Control Output Formatting Via The MySQL Shell CLI

Published Date Author: , Posted May 26th, 2021 at 3:32:31pm

Multiple Formats Available:
Table Format – use --result-format=table, alias --table
Tab Separated Format – use --result-format=tabbed, alias --tabbed
Vertical Format – use --result-format=vertical, alias --vertical
JSON Format Output – use --result-format=VALUE, alias --json[=pretty|raw|off]
VALUE may be one of:

  • json or json/pretty – These options both produce pretty-printed JSON.
  • ndjson or json/raw – These options both produce raw JSON delimited by newlines.
  • json/array – This option produces raw JSON wrapped in a JSON array.

No comments as yet.

Leave Your Comment  Leave a comment

All fields marked with "*" are required.