Monday, March 02, 2009

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();

 

No comments:

Post a comment