There are a lot of special characters in MySQL that are quite disgusting, such as single quotation marks ('), double quotation marks ("), backslash (\),...
The complete roadmap is not clear, it can only be segmented screenshots. (MySQL roadmap from Lebyte) To complete version of the roadmap, video, documentation, etc.,...
The granularity of operations can be divided into table level locks, row level locks and page level locks. Operation types can be classified into read...
This article mainly introduces the mysql data operation, some database basic add, delete, change, check operation and routine use method, let's have a look...
The database file download aggregation function used by @[TOC] queries is a function that returns a single value as input from a collection of values....
This article mainly introduces the innoDB storage engine, mainly explains a point that troubles me, whether innoDB cluster index stores primary key value or all...
Introduction Most of MySQL's transactional storage engines do not implement simple row-level locking. In order to improve concurrency performance, they generally implement multi-version concurrency control...
Mysql5.7.29 First we create a table with one field default empty string, one field defaultnull next we insert 10 data into the database, execute the...
MVCC is a must-ask interview question for advanced development, but there is currently no article on the web that can speak clearly enough; Many students...
1. In combination with the main features of MySQL database (data storage and query), the data storage occupies less space, the update and query speed...