MySQL store and get data

---restore content starts---

One, MySQL storage engine?

1. Engine definition

The storage engine is how to access the data, how to index the stored data and how to update, query the data and other technology implementation methods. Because data is in tabular form in relational data bitterness, the storage engine can also be called a table type. There is only one storage engine in Oracle and SQL Server databases so the data storage and management mechanisms are the same. and MySQL provides a variety of data storage engine, users can choose different engine for the data table according to different requirements, can also write the storage engine according to their own needs.

2.MySQL engine

Data in MySQL is stored in files or in memory using a variety of different technologies. Each of these technologies uses different storage mechanisms, indexing techniques, locking levels, and offers a wide range of different capabilities and capabilities. You can improve the overall functionality of your application by choosing different technologies that allow you to have additional speed or functionality.

3. Querying the supported storage engines in MySQL

(1) Show engines; The Terminator can also be used with a semicolon or \g

　　　　

　　　　

Eigine: Name of the storage engine

Support: Whether the engine is supported

Comment: Comments on the engine

(2) query the supported engines

Show variables like ' have% ';

　　　　

The main engine of the 4.MySQL

(1) InnoDB storage Engine

The engine has been developed for more than 10 years and has been adopted by some heavyweight internet companies such as Yahoo, Google, etc. InnoDB gives MySQL tables a transaction, rollback, crash-fix capability, and multiple versioning concurrency control and transaction security

---restore content ends---

MySQL store and get data