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

2012-07-20

shell连接mysql建立简单的md5字典#!/bin/bashUSERNAMErootPASSWORDDBmydbTABLEdict#创建数据

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