mysql - Get the sql query result without the table format

Question

Like --disable-column-names option, do we have an option to get the sql query without the table format?

example:

mysql -u username -ppassword --disable-column-names --execute "select name from test"

results below:

-----
| A |
| B |
| C |
| D |
-----

IS it possible to get the query result using some sql program option modifiers as below, [ without the table format ]

A
B
C
D

Answer 1

Add -B option to mysql.

mysql -B -u username -ppassword 
      --disable-column-names 
      --execute "select name from mydb.test"

-B, --batch : Print results in nontabular output format.

--execute : Execute the statement and quit.

HTH

Edit: Thanks to @ joescii, -B, which is short for --batch, also enables the --silent switch.