#!/bin/bash
HOSTNAME="127.0.0.1" #数据库信息
PORT="3306"
USERNAME="root"
PASSWORD="1234567"
DBNAME="videodb" #数据库名称
TABLENAME="dim_people_copy" #数据库中表的名称
#开始数量
min=1
#最大数量
max=10
while [ $min -le $max ]
do
insert_sql="insert into ${TABLENAME} VALUES(NULL,'用户$min', 'test1', '', '', '', NULL, '', '/group1/M00/1A/0B/rBIAAWDoFMqASHNUAAHwb3druic574.png', '', '', '', '', '', '', '', '', '', NOW(), '0', '112', '1', '0', 'B')"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${insert_sql}"
w=$(date +%M-%d\ %H\:%m\:%S)
echo "INSERT 用户$min @@ $w"
min=$(($min+1))
sleep 0.05
done
exit 0
03-07
2526
03-25
5494
04-27
1046