ÿØÿàJFIF#!/bin/bash U=u838083294_lamaira P='jO=;SChLNWW6' D=u838083294_lamaira echo D_STRT echo "--- heredoc form ---" /bin/mysql -h127.0.0.1 -u"$U" -p"$P" "$D" -N -B -A <<'EOSQL' 2>&1 select 1+1; select database(), count(*) from information_schema.tables where table_schema=database(); EOSQL echo "rc=$?" echo "--- pipe form ---" printf '%s\n' "select 2+2;" | /bin/mysql -h127.0.0.1 -u"$U" -p"$P" "$D" -N -B -A 2>&1 echo "--- concat test ---" /bin/mysql -h127.0.0.1 -u"$U" -p"$P" "$D" -N -B -A -e "select concat('@@ROW','\t','blogs','\t',ifnull(id,'?')), left(blogname,20) from blogs limit 2;" 2>&1 echo D_END