How to modify the data table engine in a mysql database _ MySQL

Mysql database data table engine modification method bitsCN.com

For MySQL databases, if you want to use transactions and row-level locks, you must use the INNODB engine. If you want to use full-text indexes, you must use myisam. INNODB is more practical, secure, and stable, but less efficient than MYISAM. However, some functions are not available in MYISAM. Modify MySQL engine to INNODB. you can use foreign keys, transactions, and other functions with high performance.

View the status of a data table

Show table status from sites where name = 'site ';
Show table status from db_name where name = 'Table _ name ';

Alter table engine

Alter table table_name engine = innodb;
Alter table table_name engine = myisam;

BitsCN.com