What is MySQL Index and transaction, Storage engine and example introduction

This article mainly brings you what is the MySQL index and transactions, storage engine and example introduction, the contents of the article are carefully selected and edited by the author, with a certain pertinence, for everyone's reference significance is still relatively great, the following with the author to understand the MySQL index and transactions, storage engine and examples of it.

The index in the conceptual database of the index is similar to the catalogue in the book. In a book, you can quickly find the required information book without reading the whole book. The catalogue in the book is a list of words. The index indicates the page number of each word in the database, and the index makes it unnecessary for the database program to scan the entire table. You can find the index in the desired data database | it is a collection of one-column or several column values in a table, and a list of logical pointers to the data pages that physically identify these values.