Get MySQL query statement results directly from the command line

If you need to get the results of the MySQL query statement directly from the command line, you can use the-B and-n parameters to achieve the goal.

Example: Gets the number of MySQL users.

[[email protected] ~]# mysql-bn-uroot-predhat mysql-e ' select COUNT (*) from user ' 6[[email protected] ~]#

-B Parameter: remove border

-N parameter: Show results only

This article is from the "Last Night Stars" blog, please make sure to keep this source http://yestreenstars.blog.51cto.com/1836303/1655139

Get MySQL query statement results directly from the command line