MySQL Shell 9.2  /  ...  /  Vertical Format

5.7.3 Vertical Format

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 copy
MySQL 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)