根据条件导出远程mysql数据库中某表某个字段对应的数据,到指定文件中
echo "SELECT * FROM tablename WHERE colmn='xxx';" | mysql -h192.168.*.* -u**** -p*** dbname > /tmp/filename.txt
根据条件导出远程mysql数据库中某表某个字段对应的数据,到指定文件中
echo "SELECT * FROM tablename WHERE colmn='xxx';" | mysql -h192.168.*.* -u**** -p*** dbname > /tmp/filename.txt