Get all MySQL tables from a target database to a bash variable

Get into a variable:

DB_TABLES=$(mysql -u $DB_USER -p$DB_PASS -h $DB_HOST -e "SELECT table_name FROM information_schema.tables WHERE table_schema = '$DB_NAME';" -N -B)

Next, you can get tables one by one:

for TABLE in $DB_TABLES
do
  echo $TABLE
done