|
MySQL bulk insert data script
#! / Bin / bash
i = 1;
MAX_INSERT_ROW_COUNT = $ 1;
while [$ i -le $ MAX_INSERT_ROW_COUNT]
do
mysql -uroot -proot dbname -e "insert into tablename (name, age, createTime) values ( 'HELLO $ i', $ i% 99, NOW ());"
d = $ (date +% M-% d \% H :% m :% S)
echo "INSERT HELLO $ i @@ $ d"
i = $ (($ i + 1))
sleep 0.05
done
exit 0
New forms can be
create table afs_test (
name varchar () 32,
age int (32),
createTime datetime
Insertion of thousands of data ./jiaoben.sh 100000 |
|
|
|