1, mysql -e
select_sql="select count(distinct id) from tb_test"
num=$(mysql -s -h$host -u$user -p$passwd $dbname -e "$register_sql")
-s参数的使用是减少查询字段的输出
2, mysqldump导出mysql数据
#!/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
3, mysql直接登陆数据库
#!/bin/bash user="user" passwd="password" host="192.168.0.1" mysql -h$host -u$user -p$passwd db