Skip to content

Instantly share code, notes, and snippets.

@yusiwen

yusiwen/1.sh

Created March 31, 2020 16:41
Show Gist options
  • Save yusiwen/8101a0d3902fc31893249668ebf0de93 to your computer and use it in GitHub Desktop.
Save yusiwen/8101a0d3902fc31893249668ebf0de93 to your computer and use it in GitHub Desktop.
Download ZIP
[Suppressing Column Header in Query Output] #mysql
Raw
1.sh
# To create output that contains only data values, suppress the column header row with the -N (or --skip-column-names) option
mysql -N -e "SELECT arms FROM limbs" cookbook | summarize
# -N and --skip-column-names were introduced in MySQL 3.22.20
# For older versions, you can achieve the same effect by specifying the “silent” option (-s or --silent) twice:
% mysql -ss -e "SELECT arms FROM limbs" cookbook | summarize
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment