Find the Storage Engine of a MySQL table

Here is how to locate the engine of your tables in MySQL:
All tables

SELECT table_name, engine FROM INFORMATION_SCHEMA.TABLES WHERE table_schema=DATABASE();

or

One single table

SHOW CREATE TABLE test; (replace test with your table name)
Let's share thisShare on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn