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
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/228957.html
標籤：MySQL
上一篇：practice01-資料庫01---查詢課程編號為01的學生比課程編號為02的學生成績高的所有學生的編號
下一篇：兩臺win10的mysql互連