nomdemabase="plop" ; for table in $(mysql -Be 'show tables' $nomdemabase|grep -v "Tables_in_$nomdemabase") ; do mysql -B -e "select * from $table ;" $nomdemabase ; done
Exposer toute une base ET les noms des tables pour rechercher un pattern :
nomdemabase="plop" ; for table in $(mysql -Be 'show tables' $nomdemabase|grep -v "Tables_in_$nomdemabase") ; do echo "plop:$table" ; mysql -B -e "select * from $table ;" $nomdemabase ; done | grep --color -E 'plop|pattern'