linux脚本与mysql数据库交互

#!/bin/bash

# 数据库连接参数
DB_USER="your_username"
DB_PASS="your_password"
DB_NAME="your_database"

# 执行查询
QUERY="SELECT * FROM your_table;"

# 使用mysql命令行工具执行查询
mysql -u $DB_USER -p$DB_PASS $DB_NAME -e "$QUERY"

#!/bin/bash

# 数据库连接参数
DB_USER="your_username"
DB_PASS="your_password"
DB_NAME="your_database"

# 插入数据的SQL语句
INSERT_QUERY="INSERT INTO your_table (column1, column2) VALUES ('value1', 'value2');"

# 执行插入操作
mysql -u $DB_USER -p$DB_PASS $DB_NAME -e "$INSERT_QUERY"

#!/bin/bash

# 数据库连接参数
DB_USER="your_username"
DB_PASS="your_password"
DB_NAME="your_database"

# 更新数据的SQL语句
UPDATE_QUERY="UPDATE your_table SET column1='new_value' WHERE id=1;"

# 执行更新操作
mysql -u $DB_USER -p$DB_PASS $DB_NAME -e "$UPDATE_QUERY"

#!/bin/bash

# 数据库连接参数
DB_USER="your_username"
DB_PASS="your_password"
DB_NAME="your_database"

# 删除数据的SQL语句
DELETE_QUERY="DELETE FROM your_table WHERE id=1;"

# 执行删除操作
mysql -u $DB_USER -p$DB_PASS $DB_NAME -e "$DELETE_QUERY"

GRANT ALL PRIVILEGES ON your_database.* TO 'your_username'@'localhost';
FLUSH PRIVILEGES;

mysql --default-character-set=utf8 -u $DB_USER -p$DB_PASS $DB_NAME -e "$QUERY"