mysql与shell关系_shell脚本内与mysql交互_MySQL

最新推荐文章于 2022-01-21 14:00:13 发布

weixin_40003046

最新推荐文章于 2022-01-21 14:00:13 发布

阅读量102

点赞数

文章标签： mysql与shell关系

本文链接：https://blog.csdn.net/weixin_40003046/article/details/113144568

版权

bitsCN.com

shell脚本内与mysql交互

一：

[plain] mysqlCMD="mysql -h${MYSQL_HOST} -P${MYSQL_PORT} -u${MYSQL_USER} -p${MYSQL_PASS}" create_table_sql="CREATE TABLE IF NOT EXISTS ${MYSQL_DB_NAME}.${access_table_name} ( id INT(10) NOT NULL AUTO_INCREMENT, accId INT(10) NOT NULL, URL INT(10) NOT NULL, .... PRIMARY KEY (id), INDEX URL (URL) ) COLLATE='utf8_general_ci' ENGINE=MyISAM ROW_FORMAT=DEFAULT AUTO_INCREMENT=1" empty_table_sql="TRUNCATE ${MYSQL_DB_NAME}.${table_name} " echo $create_table_sql | ${mysqlCMD} echo $empty_table_sql | ${mysqlCMD}

insert等操作同理

二：

[plain] loadsql="LOAD DATA LOW_PRIORITY LOCAL INFILE '${LOG_TEMP}' INTO TABLE ${MYSQL_DB_NAME}.${table_name} FIELDS TERMINATED BY '&' LINES TERMINATED BY '/n'(id,URL.....);" mysql -h ${MYSQL_HOST} -P ${MYSQL_PORT} -u ${MYSQL_USER} -p'${MYSQL_PASS}' -N -e "${loadsql}" insert等操作同理

bitsCN.com

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：php中文网

TAG标签：mysql