Change the Storage Engine in mysql

Query to get total number of records
Select count (*) from mytable;

Query to change the storage engine
ALTER TABLE mytable ENGINE = innodb

Comments