shell导出mysql部分数据

#!/bin/sh
SYSTEM=`uname -s`
echo "echo"$SYSTEM

if [[ $SYSTEM = "Linux" ]]; then
        echo "SYSTEM Linux"
elif [[ $SYSTEM = "FreeBSD" ]]; then
        echo "SYSTEM FreeBSD"
elif [[ $SYSTEM = "Solaris" ]]; then
        echo "SYSTEM Solaris"
else
        echo "What?"
fi #ifend
    
while read line
do
   echo $line
done <backup
    
mysql -u root<<EOF
use mysql;
select * from user into outfile '/backup/temp.txt';

原文地址:https://www.cnblogs.com/xtly2012/p/3779855.html