需求：在指定范圍內(nèi)實(shí)現(xiàn)ID和序列號(hào)、名稱等字段自增
腳本如下：
#! /bin/bash
# i為遞增ID，step為執(zhí)行次數(shù)穆端，no為遞增序列號(hào)
i=120943000000220593
step=0
no=990
while (($step<=1032))
do
((step++))
let no+=1
# echo $step
id=$(($i+$step))
# echo $id
echo "INSERT INTO SG_DATACENTER.SG_DEV_TOWER_B (REGION,SUPPLIER_ID,TYPE,ID,LONGITUDE,STAMP,TOWERNO,ALTITUDE,CHECK_CODE,MODEL,LATITUDE,OWNER,DEV_ID,OFF_TIME,ON_TIME,TOWERNAME,INITIAL_LINE,TOWERHEIGHT) VALUES(null,null,null,'$id',111.601300,'430000_00614300000295_2021-05-27 12:18:20',$no,null,null,'名稱#$no',29.090000,'430000',null,null,null,'名稱#$no',null,null);" >> insert_tower.sql
echo "INSERT INTO SG_DATACENTER.SG_DEV_DCLINE_R_TOWER (LINE_ID,TOWER_ID,OWNER,STAMP,TOWERNAME,TOWERNO,LATITUDE,LONGITUDE) VALUES ('120699010000000024','$id','430000','430000_00614300000295_2021-05-27 12:18:20','名稱#$no',$no,20,20)" >> insert_R.sql
done
