Formatting Tabular mysql results in mail on unix I am trying to email mysql query results through mail command in unix as below.

mysql -uroot -p*** -e "select query" --table|mail -s "test" abc@example.com


but format is little bit creepy kind of below.

+--------------+-------------+
| PARTNER_NAME | ORDER_COUNT |
+--------------+-------------+
| Legacy       |           0 |
| NextJump     |           0 |
| Provide      |           0 |
+--------------+-------------+  

Can you help me with formatting the output if you have any idea
The formatting is down to the client in which you are reading the result. If the client is set to fixed width font then the display formatting will be as you expect.