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 optionresultFormat tovertical.
Example 5.3 Output in Vertical Format
MySQL localhost:33060+ ssl world_x JS > shell.options.set('resultFormat','vertical')MySQL localhost:33060+ ssl world_x JS > session.runSql("select * from city where countrycode='AUT'")*************************** 1. row *************************** ID: 1523 Name: WienCountryCode: AUT District: Wien Info: {"Population": 1608144}*************************** 2. row *************************** ID: 1524 Name: GrazCountryCode: AUT District: Steiermark Info: {"Population": 240967}*************************** 3. row *************************** ID: 1525 Name: LinzCountryCode: AUT District: North Austria Info: {"Population": 188022}*************************** 4. row *************************** ID: 1526 Name: SalzburgCountryCode: AUT District: Salzburg Info: {"Population": 144247}*************************** 5. row *************************** ID: 1527 Name: InnsbruckCountryCode: AUT District: Tiroli Info: {"Population": 111752}*************************** 6. row *************************** ID: 1528 Name: KlagenfurtCountryCode: AUT District: Kärnten Info: {"Population": 91141}6 rows in set (0.0027 sec)