用shell脚本循环加判断生成sql脚本

使用shell脚本的循环加判断向一个表中插入1000000条记录。

#!/bin/bash

SQL=./insert_da_printer.sql

echo "use ise;">>${SQL}
echo "LOCK TABLES \`DA_Printer\` WRITE;">>${SQL}
echo "insert into DA_Printer(p_name,prt_ip) values ">>${SQL}
numtt=1000000
for (( i=1; i<=${numtt}; i++ ))
do
    name="printer"${i}
    ip=${i}
    cmd="('${name}', '${ip}')"
    echo $cmd>>${SQL}
    if [ ${i} -eq ${numtt} ]; then
        echo ";">>${SQL}
    else
        echo ",">>${SQL}
    fi
done

echo "UNLOCK TABLES;">>${SQL}