1 !/bin/bash 2 3 4 HOSTNAME="localhost" 5 PORT="3306" 6 USERNAME="root" 7 PASSWORD="1234" 8 DBNAME="mydatabase" 9 10 11 LOGIN_CMD="mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD}" 12 13 14 echo ${LOGIN_CMD} 15 16 17 create_database() { 18 echo "create database ${DBNAME}" 19 create_db_sql="create database if not exists ${DBNAME} character set utf8" 20 echo ${create_db_sql} | ${LOGIN_CMD} 21 22 23 if [ $? -ne 0 ] 24 then 25 echo "create database ${DBNAME} failed..." 26 exit 1 27 else 28 echo "succeed to create database ${DBNAME}" 29 fi 30 } 31 32 33 create_database
内容来源于网络如有侵权请私信删除
文章来源: 博客园
- 还没有人评论,欢迎说说您的想法!