Bash: multiline SQL statements for mysql with the heredoc syntax and vertical output

mysql-multiline-statement.command.heredoc.sh

#!/usr/bin/env bash

mysql -u root -psecret -Dworld 2>/dev/null -E -t<<EOF
SELECT *
FROM   city
WHERE  NAME = 'amsterdam';
EOF

# /* expected result -- in vertical format */:

# *************************** 1. row ***************************
#          ID: 5
#        Name: Amsterdam1
# CountryCode: NLD
#    District: Noord-Holland
#  Population: 731200

## HOWEVER This will return nothing 
# - if credentials are wrong, or 
# - if these queries return an empty resultset
# */

##################  Alternative ##############################

# /* password set in an extra config file:
# [client]
# user="root"
# password=secret
# host=localhost
# */

mysql --defaults-extra-file=$HOME/.mysql-credentials.cnf -Dworld -E -t<<EOF
SELECT *
FROM   city
WHERE  NAME = 'amsterdam1';
EOF