## background Recently, I am supporting a project from Oracle to TiDB. In order to facilitate th…
Recently, when using the SQL Server database, an error message of `error: 40` appeared unexpectedly…
## Export MySQL query data to csv file to `.csv`: ``` # mysql -h xx.xx.xx.xx -u root -p'M…
## solution ``` ALTER TABLE tablename AUTO_INCREMENT = 1 ``` > **Note**: For InnoDB, you ca…
## description error message: ``` SQL>Alter database drop logfile group 20; Alter database …
## Specific error information error message: ``` mysqldump: Error 2013: Lost connection to M…
## description What should I do when MySQL reports an error `[Error] MySQL establishment of conn…
## description Use druid to query MySql with as and report the following error: > Error query…
## error message ``` mysql ERROR 1093 (HY000): You can't specify target table 'table_name' for …
## description error message ``` ERROR 1449 (HY000): The user specified as a definer ('mysql…
## error message When doing `EF Core Migration`, the Update-dataBase command always reports an e…
### **problem** after connecting to my remote MySQL database and refresh, my Pycharm still not s…