#!/bin/bash
i=1;
while [ $i -le 10000 ]
do
mysql -uroot -proot yantest -e "insert into test(num,insertDate) values($i,now());"
let i=i+1
sleep 0.01
done
exit 0
使用shell批量向mysql中插入数据
最新推荐文章于 2023-11-01 09:22:13 发布
#!/bin/bash
i=1;
while [ $i -le 10000 ]
do
mysql -uroot -proot yantest -e "insert into test(num,insertDate) values($i,now());"
let i=i+1
sleep 0.01
done
exit 0