#10 8,13 * * * sh /home/xxxxx/exportXM.sh
#!/bin/bash
statement="use dbname1;select a.dev_sn,a.last_online_time,a.last_offline_time from w_devices a, device_xiamen b where a.dev_sn = b.dev_sn;"
mysql -u4g_svr -p4g_svr -hlogin.mysqlhost.com >/webapps/images/xiamen.xls << EOF
$statement
EOF
echo "exporting"