How to store sql query response with dotted lines into a text file?

Question

I have a simple question I want be able to store sql query response with dotted lines. So when I hit mysql with command line interface like mysql -h${sqlhost} -u${sqluser} -p${sqlpass} -e "SELECT * FROM test.employee" > output.txt I should be able to store structured output in the text file - in linux environment even Windows would do.

I should be able to store the structured view above into a say 'output.txt' file.

Answer 1

Use the --table switch, as per the documentation: https://dev.mysql.com/doc/refman/5.7/en/mysql-shell-output-table-format.html