Check if MySQL schema exists

scheme_exists.sh

table_exists() {
    db_url="$1"
    user="$3"
    password="$4"
    schema="$2"
    if [[ ! -z $(mysql -Ns -h"$db_url" -u"$user" -p"$password" -e "select schema_name from information_schema.schemata where
            schema_name='${schema}';") ]]; then
      echo "schema exists"
      return 0
    fi
    echo "schema doesn't exist"
    return 1
}

# usage
table_exists 127.0.0.1 user password schema