Getting type of engine of Mysql’s tables.

[root@server ~]# mysql -u root -pXXXXX -e 'select table_schema,table_name,engine from tables' information_schema
+--------------------+---------------------------------------+--------+
| table_schema       | table_name                            | engine |
+--------------------+---------------------------------------+--------+
| information_schema | CHARACTER_SETS                        | MEMORY |
| information_schema | COLLATIONS                            | MEMORY |
| information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | MEMORY |
| information_schema | COLUMNS                               | MyISAM |
....