Các tin tốt là bạn có thể có các loại khác nhau của bảng bên trong một cơ sở dữ liệu duy nhất, vì vậy bạn có thể sử dụng MyISAM cho các bảng mà không cần văn bản tự do tìm kiếm và / hoặc nước ngoài phím và InnoDB cho những người khác. | Simpo PDF Merge and Split Unregistered Version - http CHAPTER 5 CREATING THE PRODUCT CATALOG PART 2 119 The good news is that you can have different types of tables inside a single database so you can use MyISAM for tables that don t need free-text searching and or foreign keys and InnoDB for the others. You must be extra careful when manipulating data from MyISAM tables however because you can t rely on the database to enforce its integrity on its own. Note Foreign keys can be programmatically implemented for the storing engines types that don t support them with the aid of triggers. You can find a good tutorial about this technique at http tech-resources articles . Before implementing the rest of the product catalog tables we need to explain more about the various types of MySQL table types. MySQL Table Types MySQL supports several storage engines that can be used to store your data. When creating a new data table if not specified otherwise the default table type MyISAM is used. Following are three important table types supported by MySQL MylSAM is the default storage engine when creating new tables since MySQL when it replaced its older version ISAM . It is the fastest table type in MySQL at the cost of not supporting foreign keys CHECK constraints transactions and some other advanced features. However unlike the other table types it supports full-text searching which is very helpful when implementing the searching capability in the web site. InnoDB is a very popular and powerful database engine for MySQL that among other features supports transactions has great capability to handle many simultaneous update operations and can enforce FOREIGN KEY constraints. The engine is developed independently of MySQL and its home page is http . HEAP is a special kind of table type in that it is constructed in system memory. It cannot be used to reliably store data in case of a system failure .
