shell + mysql
发布时间:2020-12-15 20:03:12 所属栏目:安全 来源:网络整理
导读:#!/bin/bash echo "测试...................." MYSQL="mysql -h127.0.0.1 -P3306 -uroot -p123456 mysqldb" selectMaxOrderId="select max(Forder_id) from t_order" cnt=$($MYSQL -s -e "${selectMaxOrderId}") orderIds="${cnt}" #OLD_IFS="$IFS" #IFS=" "
#!/bin/bash echo "测试...................." MYSQL="mysql -h127.0.0.1 -P3306 -uroot -p123456 mysqldb" selectMaxOrderId="select max(Forder_id) from t_order" cnt=$($MYSQL -s -e "${selectMaxOrderId}") orderIds="${cnt}" #OLD_IFS="$IFS" #IFS=" " #max(Forder_id) 3013759 values=(${orderIds}) #IFS="$OLD_IFS" orderId=${values[0]} echo $orderId orderId=$[$orderId+1] echo $orderId placeOrder="INSERT INTO t_mytable VALUES ("$orderId");" echo $placeOrder $MYSQL -e "$placeOrder" updateOrderStatus="update .......... set Fstatus=10 where Forder_id=$orderId;" $MYSQL -e "$updateOrderStatus" extention="INSERT INTO ................" $MYSQL -e "$extention" data='' url='127.0.0.1:80' curl -d "$data" "$url"
(编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |