MySQL Tutorials

In SQL query in order to improve query efficiency, we often take some measures to SQL optimization of query statements, the following summarizes some of the methods, there is a need to reference. In the optimization experience of a carrier has

In the actual project, there are multiple tables associated with the relationship. It is impossible to retrieve all the data in a single table. If there is no table connection, then we need a lot of action. For example, it is necessary to find the

Classification of SQL statements by function (definition, manipulation, control, query) DDL data Definition language, defining tables, libraries, views DML Add, modify, and delete operations on data table records DCL authorization, transaction

1. What does a trigger do? A: A trigger is a special stored procedure that is executed primarily by triggering an event. It can enforce constraints to maintain the integrity and consistency of data, and can track operations within the database

First, what database Ii. Classification of databases relational database (understanding) Non-relational database Third, MySQL database Directory structure of MySQL MySQL client/server Related terms Sql MySQL Client type MySQL Log in Iv. Database

A test table with uneven data distribution is first established by testing the following tests. Use Tempdbgocreate TABLE _t ( C varchar (50)); CREATE INDEX Ix_c on _t (c); go--Add 10,000 data Insert _tselect (9999 + ID) from ( SELECT TOP 10000

This article brings to you the content is about MySQL database optimization method Summary, has certain reference value, has the need friend can refer to, hoped to be helpful to you. Learning, database optimization is divided into all aspects, here,

This article gives you the content is about MySQL start error resolution, there is a certain reference value, the need for friends can refer to, I hope to help you. Yesterday after resolving the database cross-permission operation, today opened the

This article is mainly for you to summarize the introduction of database additions and deletions to change the statement. Everyone should know that SQL is the standard computer language for accessing and working with databases. What is its main

This article introduces the master-slave synchronization principle of MySQL, master-slave synchronization configuration, master-slave synchronization delay, first of all, we first understand what is master-slave synchronization, master-slave

Restore data with backup +binlog. Scene: Last night was made fully prepared, this morning the user accidentally deleted a table by mistake. Solution: It is not recommended to restore directly in the original production environment, it is

In the MySQL write statement, the table column assignment and table type does not match, the MySQL bottom of the optimizer to play a role, will do a forced type conversion, this time can be normal operation, but will cause row lock escalation to

First, the problem scenario A table has a key field tid,action,dateline, etc., the TID represents the id,action of the Post, which represents the status of the post being manipulated, Dateline represents the timestamp of the data being inserted;

For the realization of the mutual configuration of the two machines, this article made a detailed introduction, after the test data synchronization, in the 10.168.1.44 server database to modify a piece of data, you can see the data has been

Multi-version concurrency control Most of MySQL's transactional storage engines do not implement simple row-level locks. Based on the consideration of improving concurrency performance, they generally implement multi-version concurrency control at

Build a Test table View version Information Select version (); 5.7.22 Create a parent table drop table if exists Models; CREATE TABLE Models ( modelid SMALLINT UNSIGNED not null auto_increment, Name VARCHAR (+) not NULL, PRIMARY KEY

Remember a MySQL foreign KEY constraint design flaw Background information Recently in the database migration of the project, from Oracle to MySQL, a foreign key constraint was running normally in Oracle, and the MySQL reported an exception.

Introduction Recently in the modification of data on the line, you need to now continue to back up the modified data, but the online customer's server is not directly connected, but through a bastion machine, which means that we can not directly

MySQL Query the time period of the data MySQL query based on the timestamp of the specified date not everyone will, the following is a way for you to introduce a MySQL query time period, for your reference, I hope you can enlighten. Select Now

"One-to-many" is the most common mapping relationship, simply like the relationship between consumers and orders. One-to-many: from the consumer corner of the degree of a consumer can have multiple orders, that is, a pair of more. Many-to-one: from