What will be the difference between the output on the screen and the contents of out.txt
mysql < file.sql > out.txt
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 plus line numbers.
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