How To Control Output Formatting Via The MySQL Shell CLI

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

https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-output-formats.html

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.