shell连接mysql建立简单的md5字典

   #!/bin/bash
   USERNAME="root"
   PASSWORD=""
   DB="mydb"
   TABLE="dict"
   #创建数据库
   create_db="create database if not exists $DB"
   mysql  -u $USERNAME -e "$create_db"
   #创建表
   create_table="create table if not exists $TABLE(k varchar(32),v varchar(20))"
   mysql  -u $USERNAME $DB -e "$create_table"

   for((i=$1; i<$2; i=i+1))
   do
         #  len= echo $i|wc -L
           value_tmp=0000000$i
           len=${#value_tmp}
           value=${value_tmp:$len - 8}
           key=`echo -n $value |md5sum|cut -d ' ' -f 1`
           insert_sql="insert into dict(k,v) values('$key','$value')"
           mysql  -u $USERNAME $DB -e "$insert_sql"
           echo $i
           echo $key
           echo value=$value
           echo $insert_sql
   done