Batch ALTER mysql TABLES with index;

lcount=0; echo 'Please enter your mysql username:'; read mysqluser; echo '\nPlease enter your mysql password:'; read mysqlpw; echo 'SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME="blz" AND !(COLUMN_KEY>"") AND TABLE_SCHEMA="macsi";' | mysql -u$mysqluser -p$mysqlpw macsi | while read -r line; do if [ "$line" != "TABLE_NAME" ]; then ((lcount++)); echo 'ALTER TABLE `'$line'` ADD INDEX(`blz`);' | mysql -u$mysqluser -p$mysqlpw macsi; fi; done; echo '\n'$(tput setaf 2)'Successfully altered '$(tput setaf 3)$lcount$(tput setaf 2)' tables (added index to them).';