Mysql myisam storage engine to innodb conversion method

To ensure data security, it is recommended to back up the table before switching, and disconnect other connections. The switching method is as follows:

Method 1:  Use the alert table command; data will not be lost after conversion

       alter table table_name engine=innodb;

Method 2: Use the online management tool navacat

       Open the database -- Find the corresponding table -- Right-click Design -- Options -- Change the storage engine to InnoDB -- Save

Method 3:    Export the database, recreate the table with the Innodb engine, and then import the data