简单的通过shell脚本接收参数进行数据库操作

旧城等待， 2022-06-03 01:36 300阅读 0赞

### 建表sql语句： ###

SET FOREIGN_KEY_CHECKS=0;
    
    -- ----------------------------
    -- Table structure for `cent_survival`
    -- ----------------------------
    DROP TABLE IF EXISTS `cent_survival`;
    CREATE TABLE `cent_survival` ( `centCode` varchar(32) NOT NULL, `survivalCode` char(1) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    
    -- ----------------------------
    -- Records of cent_survival
    -- ----------------------------
    INSERT INTO `cent_survival` VALUES ('0001', '1');
    INSERT INTO `cent_survival` VALUES ('0002', '1');

### 创建一个shell文件 ###

vim changeMysql.sh

### 修改文件权限 ###

chmod 777 changeMysql.sh

### 编辑内容（以修改为例） ###

#!/bin/bash
    read -t 30 -p "请输入中心代码【南0001/北0002】:" centCode
    echo -e "\n"
    read -t 30  -p "请输入中心状态码【挂机0/正常1】:" survivalCode
    HOSTNAME="127.0.0.1"  #数据库信息
    PORT="3306"
    USERNAME="root"
    PASSWORD="123456"
    
    DBNAME="test"  #数据库名称
    TABLENAME="cent_survival" #数据库中表的名称
    #查询
    select_sql="select * from ${TABLENAME}"
    mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${select_sql}"
    
    #更新数据
    update_sql="update ${TABLENAME} set survivalCode=${survivalCode} where centCode = ${centCode}"
    mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${update_sql}"
    
    mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${select_sql}"

### 测试： ###

[root@localhost local]# ./changeMysql.sh

![这里写图片描述][SouthEast]

[SouthEast]: /images/20220603/b268815877d14631976a0c329572d163.png