find all InnoDB (MyISAM) tables in mysql

All InnoDB table:

1. with  shell command line:
   # mysql -B -D INFORMATION_SCHEMA -e "SELECT table_schema, table_name FROM TABLES WHERE engine = 'innodb'; "
   

2. or with  mysql command line:

   mysql> SELECT table_schema, table_name FROM INFORMATION_SCHEMA.TABLES WHERE engine = 'innodb';

if you want find all MyISAM tables simply change @innodb@ to "MyISAM" in command