What will be the difference between the output on the screen and the contents of out.txt
mysql < file.sql > out.txt
The output on the screen will be identical to out.txt plus line numbers.
The out.txt file will hold STDERR and STDOUT will go to the screen.
The output on the screen will be identical to out.txt
There will be no output on the screen as it's being redirected to out.txt.