mysql change table engine type script

hey_man_it_works: for i in $(mysql -Be'show tables;' DATABASENAME | grep -v ^Tables_in_); do echo mysql DATABASENAME -e"ALTER TABLE $i ENGINE='INNODB';"; done