database

Record Of A Simple Process Of Migrating Oracle Offline Data To Tidb

## background Recently, I am supporting a project from Oracle to TiDB. In order to facilitate th…

Solution When Sql Server Displays Error,"Error: 40"

Recently, when using the SQL Server database, an error message of `error: 40` appeared unexpectedly…

Export Mysql Query Data To Csv File

## Export MySQL query data to csv file to `.csv`: ``` # mysql  -h  xx.xx.xx.xx  -u root -p'M…

How To Reset The Auto-Increment Of Id Auto_Increment In Mysql?

## solution ``` ALTER TABLE tablename AUTO_INCREMENT = 1 ``` > **Note**: For InnoDB, you ca…

Unable To Drop Redo Log Files As Failing With Ora-01623

## description error message: ``` SQL>Alter database drop logfile group 20; Alter database …

Mysqldump Report Error-Error 2013 Lost Connection To Mysql Server

## Specific error information error message: ``` mysqldump: Error 2013: Lost connection to M…

Mysql [Error] Mysql Establishment Of Connection

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

Sql Injection Violation, Syntax Error:Token Lparen

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

Mysql Error 1093 (Hy000)

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

Mysql Error 1449 (Hy000)

## description error message ``` ERROR 1449 (HY000): The user specified as a definer ('mysql…