shell编程操作mysql导出文件

#!/bin/bash

mysql -u"root" -p"123456" -e"
use all_university;
select university_info.sch_name,北大.research_direction from university_info,北大 where university_info.id=北大.gid and 北大.research_direction like '%生物信息%';" > /home/xshengjing/桌面/shengwu.txt