Redirecionando saida de Query SQL para arquivo TXT

[johnm@linuxbox johnm]$ echo "select * from companies where something = \"No\"" | /usr/local/mysql/bin/mysql -uUSERNAME -pPASSWORD DB_NAME > /tmp/foo.txt;