Debug the code and report an error after execution is complete ``` pymysql.err.ProgrammingError…
## Error content: ``` (156, b"Incorrect syntax near the keyword 'group'.DB-Lib error message 20…
## foreword When we use mysql or other data, we always encounter that the database occupies a lo…
## problem When the server started today, the initialization failed, and the 2036 error of mysql…
## reason `Mysqldb` is not compatible with versions later than `python3.5` ## Solution Use…
## problem I've searched for a lot of solutions online, but nothing works. No matter what you…
## probelm error when installing mysqlcliend with `pip3` ``` ERROR: Command errored out wi…
## peoblem There is no public key in the system that can verify the digital signature of this RP…
## problem When installing mysql8, I did not encounter this problem before, but this time I sudd…
## 1 Check if it is started in cluster mode In the startup script `startup.cmd`, modify `MODE="s…
## problem Install mysql error, there is no error, this is the error message ``` All matches…
## problem The `zabbix` monitor reported an error when importing the `schema.sql` file, and the…
## error When connecting to MySql database remotely ``` ERROR 1045 (28000): Access denied fo…
# error ``` Error creating bean with name'methodValidationPostProcessor' ``` Little notes …
## problem I found a lot of posts on the Internet and copied each other. The key is not to solve…
## error `MySQL Workbench 6.3` is newly installed on Win7 computer. After opening, execute an `u…
abnormal: ``` Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class i…
When I wrote the SQL statement today, I sorted the numbers relative to the string type. How to do i…
## problem MySQL workbench version `8.0.27` connects to the local MySQL database report ``` …
## Problem Description Starting the project today suddenly throws the following error message: …
## error mysql master-slave service, stop the slave server from the machine to execute the start…
## background The business installed a version of `mysql server 5.7.25` of the `percona` branch …
## background The `mysql.user` table is broken after importing the data of `mysql 5.5` version i…
## error PageHelper's unsafe paging problem, resulting in ``` ParserException: syntax error…
## conclusion first: Because there is a product description field set to `desc` in the table des…
## Start mysql8 ``` systemctl start mysqld.service ``` ## error ``` Job for mysqld.serv…
## error error when Linux installation MySQL ``` Failed dependencies: libaio.so.1()(64bit) …
## 1 mysql password reset under windows 1.1 Stop the mysql service (in the starting state) ``…
The computer crashed during use. After restarting, it was found that mysql did not start successful…
When implementing mysql master-slave replication configuration, an error is reported as shown in th…
## problem description ``` mysql> update user set authentication_string=password('mysql123') wh…
## reason When MySQL builds a table, there is a limit on the maximum length of a single row: the…
## ERROR ``` SQL ERROR [1] [08S01]: Error while processing statement: FAILED: Execution Error, …
## descriptioon In a connection query, there is no problem with the query in the MySQL query too…
Install MYSQL In execution ``` mysqld --initialize --console ``` encountered an error …
## Problem Description Received four or five master-slave disconnection and recovery text messag…
## error ``` ERROR: Command errored out with exit status 1: command: /root/.pyenv/version…
An error may occur when entering the database for the first time after installing the mysql databas…
Execute an sql statement in mysql today and report an error: ``` mysql> select sum(xxxx) from x…
## Troubleshooting ``` [root@DBMysql ~]#masterha_check_repl --conf=/etc/masterha/app1.cnf ``` …
## two types of ERROR1118 **1.** ``` ERROR 1118 (42000): Row size too large. The maximum row…
## error The following error is encountered when installing the tokudb engine: ``` Checking …
The computer room was powered off, and after mysql started, an error was reported from the library:…
## background Run and start the mysql container on the local mac docker ``` docker run -d -p…
### background Run and start the mysql container on the local mac docker ``` docker run -d -…
## problem description ``` ┌──(rabbit㉿ASUS)-[/mnt/c/Users/rabbit] └─$ mysql -uroot -p3xxxxxxxS…
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: ``` mysql> CREATE …
``` /etc/init.d/mysqld stop mysqld_safe --user=mysql --skip-grant-tables --skip-networking & upd…
## 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. ``` update salaries set salar…
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: ``` unknown error 1130 ``` ## So…
## Create table ``` drop table if exists sequences; create table sequences ( SEQUENCE_NAME…
## error statement: ``` if(ca_coupon_id is null, 0, size(ca_coupon_id)) as m_coupon_available_n…
In the Windows environment, when installing mysql for the first time, I get an error ``` ERROR…
## 1\. Statement ``` mysql> CREATE TABLE permissions ( -> role varchar(50) NOT NULL, …
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 ` 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 ``` CREATE TABLE `apply_log` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键', …
Execution data table structure error: ``` [Err] 1055 - Expression #1 of ORDER BY clause is not …
## error message ``` ### Error querying database. Cause: java.sql.SQLException: Unknown initia…
**mysql version**: 5.7.29 When importing the dump file of big data, the database is automaticall…
## DTS data synchronization error prompt: ``` DTS-1020013 Get db tables error,err msg:SELECT…
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`: ``` # mysql -h xx.xx.xx.xx -u root -p'M…
## 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 ``` select TABLE_SCHEMA, concat(tr…
## Table data Statistical data sql statement ``` SELECT name,count(*) FROM `test` GROUP BY n…
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: ``` /var…
ubuntu mysql5.7 startup prompt error ``` mysql start ERROR 2002 (HY000): Can't connect to loca…
mysql error Errcode: 13 "Permission denied" Background: After reinstalling mysql and dragging th…
## Delete mysql5.7 completely ``` #The following commands are executed in sequence sudo rm /…
## error Encountered an error when executing the sql statement: ``` [Err] 1235 - This versio…
Encountered an error when writing data: ``` django.db.utils.InternalError: (1153, "Got a packet…
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 ``` select * from `bdetector` where id in (select id from `bdetector` group b…
mysql Use the command to view the current mysql version ``` select version(); ``` The resul…
## MySql set the default value'collation\_connection' ``` SET NAMES utf8mb4 COLLATE utf8mb4_uni…
`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 ``` SELECT users…
## solution ``` ALTER TABLE tablename AUTO_INCREMENT = 1 ``` > **Note**: For InnoDB, you ca…
## Data There is a data table for targt, the data is as follows: ``` Id Name Other_Colum…
## 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 ``` django.core.exceptions…
## environment Django: how to uses bulk\_create (batch creation) to get the id after successful …