CODE EXAMPLE FOR SQL

how to check table engine in mysql

SHOW TABLE STATUS WHERE Name = 'xxx';