shell脚本操作数据库报错 mysql: command not found代码如下

Question

#!/bin/sh
HOSTNAME="localhost"
PORT="3306"
USERNAME="*"
PASSWORD="*"
DBNAME="*"
TABLENAME="*"
delete_sql="DELETE FROM * WHERE id = 'fc3859f5'"
mysql -h ${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${delete_sql}"

Answer 1

1 未设置 mysql 环境变量
2 如果不确定的话，可以写 mysql 的绝对路径