PDF (US Ltr)
- 2.4Mb
PDF (A4)
- 2.5Mb
The vertical format option prints result sets vertically instead
of in a horizontal table, in the same way as when the
\G
query terminator is used for an SQL query.
Vertical format is more readable where longer text lines are
part of the output.
To get this output format, start MySQL Shell with the
--result-format=vertical
command
line option (or its alias
--vertical
), or set the
MySQL Shell configuration option
resultFormat
to vertical
.
Example 5.3 Output in Vertical Format
Press CTRL+C to copyMySQL localhost:33060+ ssl world_x JS > shell.options.set('resultFormat','vertical') MySQL localhost:33060+ ssl world_x JS > session.sql("select * from city where countrycode='AUT'") *************************** 1. row *************************** ID: 1523 Name: Wien CountryCode: AUT District: Wien Info: {"Population": 1608144} *************************** 2. row *************************** ID: 1524 Name: Graz CountryCode: AUT District: Steiermark Info: {"Population": 240967} *************************** 3. row *************************** ID: 1525 Name: Linz CountryCode: AUT District: North Austria Info: {"Population": 188022} *************************** 4. row *************************** ID: 1526 Name: Salzburg CountryCode: AUT District: Salzburg Info: {"Population": 144247} *************************** 5. row *************************** ID: 1527 Name: Innsbruck CountryCode: AUT District: Tiroli Info: {"Population": 111752} *************************** 6. row *************************** ID: 1528 Name: Klagenfurt CountryCode: AUT District: Kärnten Info: {"Population": 91141} 6 rows in set (0.0027 sec)