How To Control Output Formatting Via The MySQL Shell CLI
erics, May 26th, 2021 |
1 |
mysql -N -B -e 'show variables like "%datadir%";' |
-N: No column headers -B: Batch mode – use tabs as field separators 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 […]
Categories: How-To's, Technology --tabbed, cli, Format, mysql, output, Plain, Table, Vertical
| 
No comments
