ejoubaud · January 1, 2016 23:19
diff --git a/pipable_mysql_output.sh b/pipable_mysql_output.sh
 mysql -uroot -e 'query;' -BN

 # -B stands for --bash which usese tab as a separator instead of the annoying tab-like pipes
 # -N stands for --skip-column-names which removes the column names header

 # Usage Example: Kills all processes created by the ejoubaud user
 mysql -uroot -e 'show processlist;' -BN | grep ejoubaud | cut -f1 | xargs -n1 kill
	mysql -uroot -e 'query;' -BN

	# -B stands for --bash which usese tab as a separator instead of the annoying tab-like pipes
	# -N stands for --skip-column-names which removes the column names header

	# Usage Example: Kills all processes created by the ejoubaud user
	mysql -uroot -e 'show processlist;' -BN \| grep ejoubaud \| cut -f1 \| xargs -n1 kill