#!/bin/bash
echo "测试...................."
MYSQL="mysql -h127.0.0.1 -P3306 -uroot -p123456 mysqldb"
selectMaxOrderId="select max(F_id) from t_order"
cnt=$($MYSQL -s -e "${selectMaxOrderId}")
orderIds="${cnt}"
#OLD_IFS="$IFS"
#IFS=" "
#max(F_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"
shell + mysql
最新推荐文章于 2024-06-06 14:43:41 发布