To be a qualified programmer, in addition to writing beautiful code, knowledge of the database is also indispensable, the following summarizes how to view and modify the MySQL database table storage Engine:
1, see the database can support the storage engine: show engines;
2. View the storage engine used by a table in a database: Show table status from Db_name where name= ' table_name ';
3, modify the table engine method: ALTER TABLE table_name ENGINE=INNODB;
4. Turn off the InnoDB engine method: Turn off the MySQL service via the "net stop MySQL" command and locate the My.ini file in the MySQL installation directory default-storage-engine= InnoDB to Default-storage-engine=myisam, change #skip-innodb to Skip-innodb, and finally start the MySQL service with the "net start MySQL" command.
View and modify the MySQL database table storage Engine
