PDF (US Ltr)
- 2.4Mb
PDF (A4)
- 2.5Mb
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 copyMySQL 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)