In the early stage of application development, the amount of data is small, and developers pay more attention to the realization of functions when developing...
Mysql InnoDB storage structure (B+Tree) Binary Tree Disadvantages: The amount of data is easily too long to form a linked list. Red black trees (essentially...
The top 10 database usage lists as of April 2021 are Oracle, MySQL, SQL Server, Redis, MongoDB, PostgreSQL, Elasticsearch, Db2, etc. We chose MySQL for...
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...
An index is a data structure (ordered) that helps MySQL obtain data efficiently. Beyond the data, the database system also maintains data structures that satisfy...
Face 6 big factories, I asked rotten ⭐MySQL⭐ often meet test questions summary (with the answer, ten thousand words summary, carefully polished, suggested collection)
DDL Data Definition Language (DDL Data Definition Language) is commonly used in: database and table management CREATE - CREATE modify - ALTER DROP - DROP...
Today we are going to start learning about InnoDB, another very important storage engine in MySQL. Talking about InnoDB, we have to talk about another...
Full-text retrieval requires special query syntax. Full text retrieval can be performed with or without indexes, but the speed of matching can be improved when...
In fact, in many database design optimization documents, there are instructions about how to optimize data types. In MySQL, we can also optimize the whole...
What is a transaction? One or more database operations that need to ensure atomicity, isolation, consistency, and persistence are called characteristics of a transaction transaction...
When the data table is too large, the performance cannot be greatly improved by ordinary query optimization techniques. In this case, partition table optimization is...
This article mainly introduces the use of case function in MySQL and matters needing attention; Use scenarios include case in column field processing, row to...
1. Referential Integrity Referential integrity requires that relationships do not allow references to nonexistent entities. The way to set referential integrity in MySQL is to...
MySQL implements read committed and repeatable read isolation levels through MVCC. For example, in the previous article on transaction isolation levels, a medium repeatable read....
MySQL has a number of built-in functions, which are described below. Table from: http://www.runoob.com/mysql/mysql-functions.INSERT INTO the table name (field1, field2,... fieldN ) VALUES ( value1,...