I am using an Ubuntu terminal. I've found answers about running .sql files, and how to save query results to an external file. How can I do them both at the same time?
I've tried this command: source /path/to/file.sql into outfile /path/to/outfile.txt.
I've tried to add into outfile /path/to/outfile.txt directly into file.sql and running source /path/to/outfile.sql.
I've tried mysql -u -p file.sql > results.txt. If I switch file.sql with something like this -e "select * from myTable", then it works fine.
How can I do this?
EDIT: Here is file.sql
select myID from Players where score > 80;
It's a simple query, but if I can figure this thing out, I can try to do bigger queries.
解决方案
You can execute SQL statements in a script file (batch file) like this:
shell> mysql db_name < script.sql > output.tab
Try this: mysql -u username -p database < file.sql > results.txt