MySQL basic data type and engine

Statement: The material used in this column is written by the VIP students of the Kay Academy, who has the right to be anonymous and has the final right to interpret the article; The Edith Academy is designed to promote students to learn from each other on the basis of public notes.

MySQL basic data type and engine

MySQL has a number of basic data types, numeric values, characters, dates, and so on.

Values are divided into integers and floating-point types:

The character type is as follows:

The date type is as follows:

There are also image types that are not commonly used.

There are engines in MySQL, and in layman's terms the engine is the management of the data in our database. There are six kinds of engines in MySQL, and the three commonly used are myisam,memory,innodb.

The advantage of the MyISAM engine is that the retrieval of data is fast, but the disadvantage is that it does not support things, and we can use the MyISAM engine when querying and adding data to database operations in a project.

Memory engine is RAM, its advantage is that the data read quickly, but the disadvantage is that only a small amount of data can be stored, if particularly large data is not suitable for this engine.

InnoDB engine is our most commonly used engine, it can support transaction operations, data recovery, performance stability, data security, in our project a lot of data operations to do transactional operations, which is one of the common reasons for the InnoDB engine.

MySQL basic data type and engine