I need to check the engine type for a table in MySQL. What is the command should be used?
SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'dbname'
Replace "dbname" with your
database name. Run it.
It looks like you're new here. If you want to get involved, click one of these buttons!