MySQL CREATE table

A property was found when the database table was created. Think this should be recorded.

Engine: This property represents a data storage engine with two choices:

1, MyISAM, default type. is the standard type of storage records and files, support full-text search, can be compressed, compared with other engines, there are most tools to check and repair the table, does not support transactions, does not support foreign keys. The emphasis is on performance, faster execution, and the ability to migrate across different systems. If executing a lot of select,myisam is a better choice.

2, InnoDB, support advanced processing such as transaction processing, support foreign keys, if the execution of a large number of select and UPDATE statements, for performance reasons, the use of InnoDB is the best choice.

If you want to modify the data storage Engine: ALTER TABLE tablename engine = MyISAM

MySQL CREATE table