Describe all tables in a MySQL database ======================================= Public domain ******************************************************************************** #!/bin/bash PASS="dbpass" DB="dbname" TABLES=$(mysql -uroot -p$PASS $DB -e 'show tables;' | tail -n +2) for TABLE in $TABLES; do echo; echo $TABLE mysql -uroot -p$PASS $DB -e "describe $TABLE" done ******************************************************************************** _BY: Pejman Moghadam_ _TAG: mysql, bash, bash-script_ _DATE: 2011-06-11 20:53:31_