単純なinsertの繰り返しと、バルクインサートのDDLを生成するスクリプト

mk_bulk_insert.bash

#!/bin/bash
if [ $# -ne 2 ]; then
	echo "$0 [the number of insert] [output file]"
	exit 1
fi

nmemb_insert=$1
ddlfile=$2

cat <<- EOF > $ddlfile
use dbstudy
truncate table emp;
EOF

echo -n "insert into emp values" >> $ddlfile

for i in `seq 1 $nmemb_insert`
do
	echo -n "(8000,'MySQL','DBA',null,sysdate(),5000,null,80)," >> $ddlfile
done

sed -i 's/,$/;/' $ddlfile

mk_many_insert.bash

#!/bin/bash
if [ $# -ne 2 ]; then
	echo "$0 [the number of insert] [output file]"
	exit 1
fi

nmemb_insert=$1
ddlfile=$2

cat <<- EOF > $ddlfile
use dbstudy
truncate table emp;
EOF

for i in `seq 1 $nmemb_insert`
do
	echo "insert into emp values(8000,'MySQL','DBA',null,sysdate(),5000,null,80);" >> $ddlfile
done