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 @@ ZZFCTHOTFIXZ"

i=$ (($i + 1))

Sleep 0.05

Done

Exit 0

You can create a new form.

CREATE TABLE Afs_test (

Name varchar () 32,

Age Int (32),

Createtime datetime

Insert 100,000 of the data for./jiaoben.sh 100000

This article from "East God to a dozen five" blog, declined reprint!

MySQL BULK Insert data script