#!/bin/bash

output="./output.txt"
db="db_name"
user="root"

tables=$(mysql -uroot ${db} -e "SHOW TABLES;")
for table in ${tables}
do
  if [ "${table}" == "Tables_in_dev_1o1" ]; then
    continue
  fi
  mysqlshow -u${user} ${db} "${table//_/\_}" >> "${output}"
  echo "" >> "${output}"
done