Suppress column names on MySQL command line output

less than 1 minute read

I use the MySQL command line interface regularly to fetch some data from a DB. Usually I want to have to column names as well, but if you want process the output of the command directly this is just a pain in the neck…

This is where the –silent and –skip-column-names is very useful.

   mysql -sN -e "select * from my_table;" -u <user> my_database