Related Documentation Download this Manual
PDF (US Ltr) - 343.3Kb
PDF (A4) - 343.0Kb
HTML Download (TGZ) - 67.2Kb
HTML Download (Zip) - 77.8Kb


MySQL Shell 8.0  /  ...  /  Tab Separated Format

4.6.2 Tab Separated Format

The tab separated format is used by default for printing result sets when running MySQL Shell in batch mode, to have better output for automated analysis.

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

>echo "select * from sakila.actor limit 3;" | mysqlsh --classic --uri user@192.0.2.20:33460
actor_id        first_name      last_name       last_update
1       PENELOPE        GUINESS 2006-02-15 4:34:33
2       NICK    WAHLBERG        2006-02-15 4:34:33
3       ED      CHASE   2006-02-15 4:34:33