Query to get MySQL table type

The following command can be used to get the type (engine) of MySQL table from current database in select query:

SELECT table_name, engine FROM information_schema.tables WHERE table_name="your_table" AND table_schema=DATABASE();