The MySQL UNION operator is used to join the results of more than two SELECT statements into a result set. Multiple SELECT statements delete duplicate...
1. Background This article discusses some principles and methods for performance optimization. 2. Knowledge of common optimization methods: query optimization database table structure design optimization...
Front-end partners with the rise of Node.js can quickly enter the full stack development, but a good command of SQL statements is a basic requirement....
Before studying foreign keys, we must first understand the concept of "referential integrity". Attribute values in the referenced relationship must be able to be found...
You can rename tables in a database using native SQL, but MySQL does not directly support database renaming. Describes how to use a Python implementation...
Explain the MySQL database from 11 aspects: MySQL architecture, storage engine, data types, indexes, SQL statements, transactions, locking mechanism, performance optimization, partition, sub-table and sub-library,...
The database command specifies that all database object names must be lowercase and underlined; Disallow MySQL reserved keywords for all database object names (if the...
From the perspective of logical architecture, MySQL is divided into two parts: server layer and storage engine layer. The Server layer can be divided into...
Note: The notes from the high-performance scalable MySQL database architecture design and optimization, self-collation. I. Project Description: The background of this note is the e-commerce...
MySQL master-slave replication MySQL master-slave replication MySQL multi-instance database setup MySQL multi-instance database startup and shutdown MySQL single-master multi-slave architecture MySQL Dual-master dual-slave configuration Enable...
Single-valued index: that is, an index contains only a single instance, and a table can have multiple single-valued indexes. Unique index: The value of the...
Just yesterday morning, I had Apache2.4.33 and PHP7.2.4 environments installed for the cloud server and was ready for a new MySQL5.7.22. Look for the 5.7...
Transactions, isolation, and MySQL locks cover most concurrency control scenarios. So let's take a closer look at MySQL concurrency control. First, let's review transactions, isolation...