list tables in mysql

[sulekha]

Hi all,


How to get the list of tables in mysql from a particular database based on engine type(MyISAM,InnoDB,MERGE,HEAP,BDB etc) ?

[sujoy]

SHOW TABLE STATUS FROM [name of database];

or better yet

$ mysql -u username -p -e "SHOW TABLE STATUS FROM database_name" | awk '{print $1, $2}'|column -t