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…