shell脚本中导入mysql数据&&执行mysql语句

最新推荐文章于 2024-09-20 18:06:07 发布

white__cat

最新推荐文章于 2024-09-20 18:06:07 发布

阅读量2w

点赞数

分类专栏： linux

164 篇文章 2 订阅

订阅专栏

在线下做mysql数据分析的时候，会遇到执行shell脚本里导入sql文件到mysql数据库里或者连接mysql执行指定sql语句的情况，这里介绍一下我采用的方法

[html] view plain copy print ?

"<"运算符的使用

[html] view plain copy print ?

--execute=statement, -e statement
xecute the statement and quit. The default output format is like that produced with --batch

[html] view plain copy print ?

--silent, -s
Silent mode. Produce less output. This option can be given multiple times to produce less and less output.

[html] view plain copy print ?

注意：

[html] view plain copy print ?

echo "select count(distinct id) from tb_test" | mysql -h$host -u$user -p$passwd $dbname

ps:我建议使用-e参数，更加方便吧

[html] view plain copy print ?

[html] view plain copy print ?

#!/bin/bash
#变量定义
host="127.0.0.1"
user="root"
passwd="123456"
dbname="test"
tablename="tb_test"
mysqldump -u$user -p$passwd -h$host $dbname $tablename --where "id > 1 and id < 1000" > 1.sql

[html] view plain copy print ?

--no-data, -d
Do not write any table row information (that is, do not dump table contents). This is useful if you want to dump only the CREATE TABLE statement for the table (for example, to create an empty copy of the table by loading the dump file).