linux下自动向MySQL中录入数据的脚本

作者佚名技术来源 Linux系统浏览发布时间 2012-05-14

#!/bin/sh
echo " #############################################################################################"
echo " ## The Shell Script for Postfix Cyrus-sasl Courier-authlib Mysql ##"
echo " ## ##"
echo " ## Modified: Hu Changwen ##"
echo " ## MSN : hucw_rhce@hotmail.com ##"
echo " ## Version : 1.0 ##"
echo " ## Date : 2008-09-26 ##"
echo " #############################################################################################"
echo "" #define the strcture of table
TABLE="(username char(50) not null,password char(20) not null,uid char(10) not null,gid char(10) not null,maildir char(100) not null,domain char(20) not null,active char(1) default ''1'');" #create database and table
#
for type in database table;do
printf "Please input the $type name you would like to create:[postfix]"
while read data;do
if [ ! -z ${data} ]; then
if [ "$type" = "database" ];then
database=$data
elif [ "$type" = "table" ];then
table=$data
fi
break
fi
printf "Please input the database name you would like to create:[postfix]"
done
done

# #input the data per user
#
for ((i=1;;i ));do
printf "Do you want to input the data per user:[yes,no]" 拥有帝国一切，皆有可能。欢迎访问phome.net
while read yes_no;do
if [ "$yes_no" != "yes" ];then break 2;fi
echo "Please input the data of NO.$i user:"
for col in username password uid gid maildir domain active;do
printf "$col of NO.$i :" && read ${col}[${i}]
done
break
done
done #output the data you input
#
echo ""
echo " "
echo "Please make sure the data you input:"
echo "Database: $database"
echo "Table : $table"
echo ""
echo "Show the recodes you input:"
echo "username password uid gid maildir domain active"
for ((n=1;n<i;n ));do
echo "${username[$n]} ${password[$n]} ${uid[$n]} ${gid[$n]} ${maildir[$n]} ${domain[$n]} ${active[$n]}"
done # #execute the sql to input data to mysql
#
echo ""
echo "Executing the SQL to input data to mysql......"
printf "Creating database $database......

凌众科技专业提供服务器租用、服务器托管、企业邮局、虚拟主机等服务，公司网站：http://www.lingzhong.cn 为了给广大客户了解更多的技术信息，本技术文章收集来源于网络,凌众科技尊重文章作者的版权，如果有涉及你的版权有必要删除你的文章，请和我们联系。以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢!

1 2 下一页

分享到：更多

你可能对下面的文章感兴趣

上一篇: linux下编译postfix时，使其支持mysql,ldap,sasl,ssl的脚本下一篇: 搭建linux DHCP 服务器

关于linux下自动向MySQL中录入数据的脚本的所有评论

随机推荐