MySQL

When learning the activiti process engine, integrating activiti with springboot can automatically d…

## error occured In MySQL8.0, create a user for master-slave replication: ```plaintext mysql…

```plaintext /etc/init.d/mysqld stop mysqld_safe --user=mysql --skip-grant-tables --skip-networki…

## problem description Check the content in the binlog and find that it cannot be viewed normall…

I made the simplest mistake when I was doing SQL problems today. ```plaintext update salaries …

After many trials, the steps to reset the password are as follows **step1**. Open the command wi…

## I am Redis Hello, I am Redis, and a man named Antirez brought me into this world. ![redis]…

At that time, I wanted to use `SQLyog` to remotely connect to the database, but found that I could …

## Preface When I write sql query, the most commonly used query is where conditional query. …

Use Navicat to link MySQL, and an error like this appears: ```plaintext unknown error 1130 ```…

## Create table ```plaintext drop table if exists sequences; create table sequences ( SEQU…

## error statement: ```plaintext if(ca_coupon_id is null, 0, size(ca_coupon_id)) as m_coupon_av…

In the Windows environment, when installing mysql for the first time, I get an error  ```plainte…

## 1\. Statement ```plaintext mysql> CREATE TABLE permissions ( -> role varchar(50) NO…

Failed to create user creation. `ERROR 1728 (HY000): Cannot load from mysql.procs_priv. The table i…

## Problem Description When using Azure Function to create a new Python Function, `ModuleNotFoun…

## Reason The connection read timeout, MYSQL loses the connection, and the service has been disc…

## reason I went and I imported the **mysql5** package ![ mysql5 package](https://static-work…

## solution ```plaintext mysql> CREATE USER 'mysql.infoschema'@'localhost' IDENTIFIED BY 'passw…

Solution for the `2003-Can’t connect to Mysql on ‘host name’ (10061)` error when use navicat to con…

Today the company’s project view query reported an error. I looked for the code and the reason for …

## Table ```plaintext CREATE TABLE `apply_log` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMEN…

Execution data table structure error: ```plaintext [Err] 1055 - Expression #1 of ORDER BY claus…

## error message ```plaintext ### Error querying database. Cause: java.sql.SQLException: Unkno…

**mysql version**: 5.7.29 When importing the dump file of big data, the database is automaticall…

## DTS data synchronization error prompt: ```plaintext DTS-1020013 Get db tables error,err m…

I did a test recently, and the main thread business processing logic is relatively long. I found th…

## Export MySQL query data to csv file to `.csv`: ```plaintext # mysql  -h  xx.xx.xx.xx  -u …

## background For some purposes, it is necessary to frequently delete all data of a specified se…

Query the amount of disk space occupied by all databases ```plaintext select TABLE_SCHEMA, …

## Table data Statistical data sql statement ```plaintext SELECT name,count(*) FROM `test` G…

What is the .frm.ibd file in ubuntu mysql? `.ibd`: stores metadata of each table, including the …

ubuntu reinstall mysql and restore data through .frm.ibd ## mysql storage location: ```plaint…

ubuntu mysql5.7 startup prompt error ```plaintext mysql start ERROR 2002 (HY000): Can't connec…

mysql error Errcode: 13 "Permission denied" Background: After reinstalling mysql and dragging th…

## Delete mysql5.7 completely ```plaintext #The following commands are executed in sequence …

## error Encountered an error when executing the sql statement: ```plaintext [Err] 1235 - Th…

Encountered an error when writing data: ```plaintext django.db.utils.InternalError: (1153, "Got…

Insert a large amount of data into a table in batches. For example, insert name into the tags ta…

## background In the tens of thousands of records in the people table, there are some identical …

## Error message ```plaintext select * from `bdetector` where id in (select id from `bdetector…

mysql Use the command to view the current mysql version ```plaintext select version(); ``` …

## MySql set the default value'collation\_connection' ```plaintext SET NAMES utf8mb4 COLLATE ut…

`count(1)` and `count()` are generally used to count the amount of data in the entire table, includ…

SQL query data in a certain time range ## sql statement ### first method ```plaintext SEL…

## solution ```plaintext ALTER TABLE tablename AUTO_INCREMENT = 1 ``` > **Note**: For InnoD…

## Data There is a data table for targt, the data is as follows: ```plaintext Id Name Ot…

## Introduction Fast paging can be achieved in django, but when the data reaches several million…

**Django model layer (database) connection processing logic:** 1. Use `CONN_MAX_AGE` configurat…

## problem Using the Django Debug Toolbar, I found that the sql statement to count the number of…

Sometimes you want to know how Django ORM makes our queries execute, or what the SQL corresponds to…

## Introduction It is important to understand that the options in the Django model field definit…

## environment * python=3.8 * django=3.1 ## error message ```plaintext django.core.e…

## environment Django: how to uses bulk\_create (batch creation) to get the id after successful …

Solve `Incorrect string value: ‘\xF0\x9F\x8C\xB8’ for column'xxx' at row 1` error caused by storing…

## error message ```plaintext django.db.utils.InterfaceError: (0, '') ``` ## Reasons for da…

## description The Laravel log file reports a lot of errors:  ```plaintext production.ERROR:…

## Specific error information error message: ```plaintext mysqldump: Error 2013: Lost connec…

## description What should I do when MySQL reports an error `[Error] MySQL establishment of conn…

## description Problems with using MySql to build tables When using Navicat Premium to run sq…

## description error message: ```plaintext ERROR: Please install mysql2 package manually ``…

## Connect Mysql with Python ```plaintext import mysql.connector conn = mysql.connector.connec…

## description Laravel 5.4 uses utf8mb4 character encoding by default instead of the previous ut…

## description Use druid to query MySql with as and report the following error: > Error query…

## error message ```plaintext mysql ERROR 1093 (HY000): You can't specify target table 'table_n…

## description error message ```plaintext ERROR 1449 (HY000): The user specified as a define…

As the title, this chapter mainly talks about some handling experience when the server appears `ERR…

## Error message ```plaintext public function uploads($count) { $items = \DB::tab…

## calculation Suppose there is a table called `table_name`; there are four fields: ```plaint…

Recently get a project, there is a demand that requires PC to read information and write to the dat…