shell script to run mysql query code example

Example: automate mysql cli query

#!/bin/bash
mysql -u root -psecret <<MY_QUERY
USE mysql
SHOW tables
MY_QUERY