Mysql database How to modify the data table engine _mysql

For MySQL databases, you must use the InnoDB engine if you want to use transactions and row-level locks. If you want to use Full-text indexing, you must use MyISAM. InnoDB's practicality, security, stability is higher but the efficiency than myisam slightly worse, but some function is MyISAM not. Modify the MySQL engine for InnoDB, you can use foreign keys, transactions and other functions, high performance.

View the status of a datasheet

Copy Code code as follows:

Show TABLE STATUS from sites WHERE name= ' site ';
Show TABLE STATUS from db_name WHERE name= ' table_name ';

Change the engine of a table

Copy Code code as follows:

ALTER TABLE table_name ENGINE=INNODB;
ALTER TABLE table_name ENGINE=MYISAM;