MySQL modifies the storage engine of all tables under a database to the INNODB type statement

How to change the MyISAM type table in a MySQL database to a table of type InnoDB

Change a single table

ALTER TABLE TABLENAME ENGINE=InnoDB; ALTER TABLE TABLENAME ENGINE=MyISAM;

Change multiple tables

SELECT '  "'  engine=innodb; ' )from  information_schema.tablesWHERE='DBNAME ' 0 10000 ; 

Instructions for use:

1. Replace the DBNAME in the above SQL statement with the name of the database you want to modify.

2. Execute SQL, this time has not been modified, just gave a query result.

3. Copy the query results, remove the front and back quotation marks, and then execute.

MySQL modifies the storage engine of all tables under a database to the INNODB type statement