mysql -e 格式化显示 mysql 格式化输出

几种格式化输出mysql数据的方式

# /usr/local/mysql/bin/mysql -uUSER -pPASSWD -DStatistic -e"select * from Statistic"

# /usr/local/mysql/bin/mysql -uUSER -pPASSWD -N -DStatistic -e"select * from Statistic"

# /usr/local/mysql/bin/mysql -uUSER -pPASSWD << eof
> select * from Statistic.Statistic;
> eof
/usr/local/mysql/bin/mysql -uUSER -pPASSWD -N << eof
> select * from Statistic.Statistic;
> eof