How do i know if a mysql table is using myISAM or InnoDB Engine
- by kamal
I want to confirm if the statement below is indeed true:
There is no way to specify a storage engine for a certain database, only for single tables, You can, however, specify a storage engine to be used during one session with:
SET storage_engine=InnoDB;
so you don't have to specify it for each table.
How do i confirm, if indeed all the tables are using InnoDB
All the tables were using myISAM.