As a partial answer: mysql -N -B -e "select people, places from things"
-N tells it not to print column headers. -B is “batch mode”, and uses tabs to separate fields.
If tab separated values won’t suffice, see this Stackoverflow Q&A.
As a partial answer: mysql -N -B -e "select people, places from things"
-N tells it not to print column headers. -B is “batch mode”, and uses tabs to separate fields.
If tab separated values won’t suffice, see this Stackoverflow Q&A.