How do you get table-formatted output from MySQL i

Question

This question already has answers here:

MYSQL differs in Output from script (2 answers)

Closed 12 months ago.

I like the table output that the mysql client program produces in interactive mode, but if I try to run a sql script like this:

mysql -uroot mydb < myscript.sql

I only get tab-separated output.

mysql -uroot mydb -e 'select * from mytable'

does produce the output in the desired table format, however.

How can I get the first command to produce table-formatted output? I don't want HTML output, but the terminal character output with aligned columns and headers.

Answer 1

Add the -t option to mysql (table).

  mysql -t -uroot mydb < myscript.sql

  mysql -t -uroot mydb -e 'select * from mytable'

Answer 2

Use \P less -S option before running the query

mysql> \P less -S

PAGER set to 'less -S'