mysql

mysql -u root -p  information_schema -e \
"select TABLE_SCHEMA,TABLE_NAME, ENGINE from TABLES where\
 ENGINE != 'Innodb' \
 and TABLE_SCHEMA not in ('mysql','information_schema');"

Posted by Raj Shekhar in geek stuff, mysql at 22:21 | Comments (0) | Trackbacks (0)