database

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

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

doporos created at Aug. 5, 2021, 2:09 p.m.

Export Mysql Query Data To Csv File

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

doporos created at Aug. 5, 2021, 1:56 p.m.

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

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

robot18 created at July 26, 2021, 11:48 p.m.

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

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

robot18 created at July 11, 2021, 6:06 a.m.

Mysqldump Report Error-Error 2013 Lost Connection To Mysql Server

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

robot18 created at July 7, 2021, 6:49 a.m.

Mysql [Error] Mysql Establishment Of Connection

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

robot18 created at July 6, 2021, 5:29 p.m.

Sql Injection Violation, Syntax Error:Token Lparen

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

robot18 created at July 5, 2021, 3:05 p.m.

Mysql Error 1093 (Hy000)

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

robot18 created at July 5, 2021, 2:29 p.m.

Mysql Error 1449 (Hy000)

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

robot18 created at July 5, 2021, 2:15 p.m.

An Error Occurred Using The Connection To Database On Server

## error message When doing `EF Core Migration`, the Update-dataBase command always reports an e…

robot18 created at July 5, 2021, 2:11 p.m.

Pycharm Not Showing Tables Of Database In Schemas

### **problem** after connecting to my remote MySQL database and refresh, my Pycharm still not s…

TwoPunch created at March 7, 2021, 11:06 a.m.