MySQL Shell 9.2  /  ...  /  Table Format

5.7.1 Table Format

The table format is used by default for printing result sets when MySQL Shell is in interactive mode. The results of the query are presented as a formatted table for a better view and to aid analysis.

To get this output format when running in batch mode, start MySQL Shell with the --result-format=table command line option (or its alias --table), or set the MySQL Shell configuration option resultFormat to table.

Example 5.1 Output in Table Format

Press CTRL+C to copy
MySQL localhost:33060+ ssl world_x JS > shell.options.set('resultFormat','table') MySQL localhost:33060+ ssl world_x JS > session.sql("select * from city where countrycode='AUT'") +------+------------+-------------+---------------+-------------------------+ | ID | Name | CountryCode | District | Info | +------+------------+-------------+---------------+-------------------------+ | 1523 | Wien | AUT | Wien | {"Population": 1608144} | | 1524 | Graz | AUT | Steiermark | {"Population": 240967} | | 1525 | Linz | AUT | North Austria | {"Population": 188022} | | 1526 | Salzburg | AUT | Salzburg | {"Population": 144247} | | 1527 | Innsbruck | AUT | Tiroli | {"Population": 111752} | | 1528 | Klagenfurt | AUT | Kärnten | {"Population": 91141} | +------+------------+-------------+---------------+-------------------------+ 6 rows in set (0.0030 sec)