1.命令行
1)mysql -h host -u username -p pwd dbName -e "select * from t_users" > data.log
2)cat读取sql 再输出到 mysql命令
cat select.sql | mysql -h xx -uxx -pxx dbName
或者在select.sql中指定 use dbName
select.sql如下:
show databases;
use dbName;
show tables;
select * from t_users
2.输入重定向, 独立的sql文件 , 输出重定向
1)新建addUser.sql:
insert into t_users(id,name) values(1,'tom'); select * from t_users; |
2)mysql -h host -u username -p pwd dbName < addUser.sql > query.log