Format the output to sent in Email

Shell Programming and Scripting
1

Hi

I have a script

#!/bin/sh


# email addresses to send results to, separated by a space
EMAILS="xxxx.yyyy@yahoo.com"

SUBJECT="MySQL reporting "
DISK_DATA_USAGE=/home/aaaa/usaage.txt
mysql YYYYYYYY -e " select 100*sum(max_data_length) as disk_usage_pct from xxxxxx;" > /home/aaaa/usaage.txt

mysql ndbinfo -e "select node_id, memory_type, 100*used memory_usage_pct from xxxxx >> /home/aaaa/usaage.txt

mysql ndbinfo -e "SELECT node_id, 100*(page_requests_wait_io) as hit_ratio_pct FROM XXXX;" >> /home/aaaa/usaage.txt

/bin/mailx -s "$SUBJECT" "$EMAILS" < $DISK_DATA_USAGE

/bin/rm/$DISK_DATA_USAGE

the output in the email is not formatted correctly

 disk_usage_pct
  162.5000
  node_id          memory_type            memory_usage_pct
  4          Data memory            96.4871
  4          Index memory            88.4126
  6          Data memory            96.6160
  6          Index memory            88.3879
  node_id          hit_ratio_pct
  4          97.9363
  6          98.0097

how do I correct the format of the output.

2 
 
mysql --help

MySQL :: MySQL 5.0 Reference Manual :: 4.5.1.1 mysql Options

Are you looking for the -t option ?

3

THe output in usaage.txt is in tabular format but when email is send than the format changes.
how do I change my code so that the format read from the usaage.txt is in tabular format when a email is sent.

thanks