#!/bin/bash
# 配置数据库连接信息
DB_HOST="your_mariadb_ip"
DB_PORT="your_mariadb_port"
DB_USER="your_username"
DB_PASS="your_password"
DB_NAME="your_database_name"
TABLE_NAME="your_table_name"
# 检查数据库服务是否可达
function check_db_service {
echo "Checking if the database service is available..."
mysql -h "$DB_HOST" -P "$DB_PORT" -u "$DB_USER" -p"$DB_PASS" -e "exit" > /dev/null 2>&1
if [ $? -eq 0 ]; then
echo "Database service is up and running."
return 0
else
echo "Failed to connect to the database service."
return 1
fi
}
# 更新数据库表数据
function update_db_data {
echo "Updating data in the database table..."
# 这里使用mysql命令来执行SQL语句
# 请替换下面的SQL语句以匹配你的实际需求
UPDATE_SQL="UPDATE $TABLE_NAME SET column_name='new_value' WHERE condition;"
mysql -h "$DB_HOST" -P "$DB_PORT" -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" -e "$UPDATE_SQL"
if [ $? -eq 0 ]; then
echo "Data updated successfully."
else
echo "Failed to update data."
fi
}
# 主程序
if check_db_service; then
update_db_data
else
echo "Exiting script due to database service not available."
exit 1
fi