1. MyISAM: The default table type, which is based on the traditional ISAM type, ISAM is an abbreviation for indexed sequential access method (indexed sequential access methods), which is the standard way to store records and files. It is not
The difference and choice between MyISAM and InnoDB, detailed summary, performance comparisonJune 25, 2015 21:58:42 read: 1827 more personal Category: MySQL1. MyISAM: The default table type, which is based on the traditional ISAM type, ISAM is an
InnoDB and MyISAM Difference summaryI used MySQL with Navicat for MySQL (Navicat for MySQL v9.0.15 registration code generator) Operation library, table operation, the default table is the InnoDB type, also do not care. Recently do the project found
InnoDB:Support transaction processing, etc.No lock ReadSupport for foreign keysSupport Row lockIndex of type Fulltext not supportedDo not save the table's exact number of rows, scan the table to calculate how many rowsDelete Table is a row of
1. MyISAM: The default table type, which is based on the traditional ISAM type, ISAM is an abbreviation for indexed sequential access method (indexed sequential access methods), which is the standard way to store records and files. It is not
InnoDB and MyISAM are the two most common table types used by many people when using MySQL, both of which have pros and cons, depending on the application. The basic difference is that the MyISAM type does not support advanced processing such as
The common MySQL table engine has InnoDB and MyISAM, the main difference is that InnoDB is suitable for frequent write database operations, MyISAM suitable for reading the database a little bit more, how to change the table engine InnoDB to MyISAM?
Set MySQL data table primary key: Use the "PRIMARY key" keyword to create a primary key data column. The primary key column is set to not allow duplicate values, in many cases combined with "auto_increment" incrementing numbers. As shown in the
If a field of one entity points to the primary key of another entity, it is called a foreign keyThe entity that is pointed to is called the primary entity (the primary table), also called the parent entity (the parent table).The entity that is
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.