Return to Answer

code block

Source Link

edit approved May 24, 2016 at 6:34

user14755

try out this-

count=$($path/./mysql -h $ip -u $user -p$password $schema -s -e "select count(1) from employee where [email protected]");

if [[ "${count}" = '0' ]]; then break else echo "Email exist, please enter a new value : " fi

count=$( $path/to/mysql -h $ip -u $user -p$password $schema -s \
          -e "select count(1) from employee where [email protected]");

if [[ "${count}" = '0' ]]; then
    break
else
    echo "Email exist, please enter a new value : "
fi

try out this-

count=$($path/./mysql -h $ip -u $user -p$password $schema -s -e "select count(1) from employee where [email protected]");

if [[ "${count}" = '0' ]]; then break else echo "Email exist, please enter a new value : " fi

try out this-

count=$( $path/to/mysql -h $ip -u $user -p$password $schema -s \
          -e "select count(1) from employee where [email protected]");

if [[ "${count}" = '0' ]]; then
    break
else
    echo "Email exist, please enter a new value : "
fi

Source Link

answered May 24, 2016 at 6:10

Sunil Verma

try out this-

count=$($path/./mysql -h $ip -u $user -p$password $schema -s -e "select count(1) from employee where [email protected]");

if [[ "${count}" = '0' ]]; then break else echo "Email exist, please enter a new value : " fi