Documentation Home
MySQL Shell 8.0
Related Documentation Download this Manual
PDF (US Ltr) - 370.8Kb
PDF (A4) - 367.3Kb
HTML Download (TGZ) - 73.8Kb
HTML Download (Zip) - 85.7Kb

MySQL Shell 8.0  /  ...  /  Tab Separated Format

5.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 limit 3;" | mysqlsh --classic --uri user@
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