Home  >  Article  >  Database  >  Linux下自动向MySQL中录入数据的脚本

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

WBOY
WBOYOriginal
2016-06-07 17:01:301460browse

#!/bin/sh#define the strcture of tableTABLE=quot;(username char(50) not null,password char(20) not null,uid char(10) no

#!/bin/sh
#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]"
    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    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......                  " && \
      mysql -u root -h --password=RedHat -e "create database if not exists ${database}" && \
      echo -e "\033[32mOK\033[m"
      printf "Creating table $table......                      " && \
      mysql -u root -h --password=redhat $database -e "create table if not exists ${table}$TABLE" && \
      echo -e "\033[32mOK\033[m"
#insert recode to mysql
for ((n=1;n     printf "Insert NO.$n recode......                   " && \
     mysql -u root -h --password=redhat $database -e "insert into $table values ('${username[$n]}',encrypt('${password[$n]}'),'${uid[$n]}','${gid[$n]}','${maildir[$n]}','${domain[$n]}','${active[$n]}')" && \
     echo -e "\033[32mOK\033[m"
done
#show all the recode
echo ""
echo "Show all the recods in the mysql:"
mysql -u root -h --password=redhat $database -e "select * from $table"

linux

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn