How to BULK Insert data in MySQL tables with shell scripts _linux shell

Many times you need to insert a lot of test data into the MySQL table, and share a way to generate the MySQL test data in a while loop using a shell script, and you just need to generate SQL statements based on your own table structure.

Copy Code code as follows:

#!/bin/bash

I=1;
max_insert_row_count=$1;
While [$i-le $MAX _insert_row_count]
Todo
Mysql-uroot-proot afs-e "INSERT into Afs_test (name,age,createtime) VALUES (' hello$i ', $i% 99,now ());"
d=$ (date +%m-%d\%h\:%m\:%s)
echo "INSERT HELLO $i @@ ZZFCTHOTFIXZ"
i=$ (($i + 1))
Sleep 0.05
Done

Exit 0

Assuming that the above shell script is saved as create-data.sh, you can generate the data by using the following command:

Copy Code code as follows:

SH create-data.sh 10000

* Note: Parameter 10000 is the number of data bars to generate.