How to store MySQL results to a file in table format
This should do the trick:
mysql -u root -p -t -vvv < select.sql | sed '1 d' > output.txt
This should do the trick:
mysql -u root -p -t -vvv < select.sql | sed '1 d' > output.txt