如何检查MySQL表是否为UTF-8并具有storageEngine InnoDB？

select table_name,engine 
from information_schema.tables
where table_schema = \'your_database\'

show create table table_name

select 
c.character_set_name 
from information_schema.tables as t,
     information_schema.collation_character_set_applicability as c
where c.collation_name = t.table_collation
and t.table_schema = \"your_db\"
and t.table_name = \"table_name\";