mysql shell可视化_Mysql Shell 脚本

连接Mysql Shell脚本

本地连接及远程链接

#!/bin/bash

#连接MySQL数据库

Host=127.0.0.1

User=username

PASSWORD=password

PORT=3306

DBNAME="test_db_test"

TABLENAME="test_table_test"

CREATE_DB_SQL="SELECT * FROM ${DBNAME}.${TABLENAME}"

#本地连接

mysql -u$User -p$PASSWORD <

use ${DBNAME};

SELECT * FROM ${DBNAME}.${TABLENAME};

COMMIT;

EOF

if [ $? = 0 ];then

echo "create yes"

fi

#远程连接

mysql -h$Host -u$User -p$PASSWORD <

use DATABASE_NAME;

SELECT * FROM TABLE_NAME;

EOF

-e 方式连接

#!/bin/bash

#连接MySQL数据库

Host=127.0.0.1

User=username

PASSWORD=password

PORT=3306

DBNAME="test_db_test"

TABLENAME="test_table_test"

CREATE_DB_SQL="SELECT * FROM ${DBNAME}.${TABLENAME}"

mysql -h${Host} -P${PORT} -u${User} -p${PASSWORD} -D ${DBNAME} -e "${CREATE_DB_SQL}"

if [ $? = 0 ];then

echo "create yes"

fi

流川枫_

发布了0 篇原创文章 · 获赞 0 · 访问量 11

私信

关注

标签：脚本,Shell,DB,TABLENAME,User,Mysql,test,PASSWORD,DBNAME

来源： https://blog.csdn.net/weixin_44367066/article/details/103985842