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
The out.txt file will hold STDERR and STDOUT will go to the screen.
There will be no output on the screen as it's being redirected to out.txt.
The output on the screen will be identical to out.txt plus line numbers.