Necessary knowledge points of MySQL development log file

Necessary knowledge points of MySQL log file development Reference source: juejin.im/post/5b7c0aabf265da438415b9eb preface Log files record all kinds of activities that affect MySQL database. Common log files in MySQL database include error log, binary log, slow query log and query log. They are i ...

Posted by Yucky on Tue, 30 Jun 2020 00:40:28 -0700

Evaluation of million level data migration scheme

preface Recently, when the company used ABP to reconstruct the old project, the database was also switched from SQL SERVER to MySql. Tucao, the products used before make complaints about Windows Server 2008, SqlServer 2008R2,.Net Framework 4.5, and now embrace.net core. Back to the point. At present, there are 10w + and 100w + data in a single ...

Posted by cdwhalley.com on Mon, 29 Jun 2020 20:15:36 -0700

GRpc exception handling Filter

Global error handling server Microsoft has implemented it Interceptors They are similar to Filter or Middlewares stay ASP.NET MVC core or web API, they can be used for global exception handling, logging, validation, etc. This is the server-side Interceptor's own implementation. Continuation is a Task that must wait. Then, if any exception is ...

Posted by ahundiak on Mon, 29 Jun 2020 17:54:30 -0700

nodejs crawler project

The news data of several websites have been crawled before. Now we need to organize and display these data. The specific requirements are as follows The first step is to install the dependency package in npm install under the final project folder Here, I met a problem during the installation process. Th ...

Posted by moonman89 on Sun, 28 Jun 2020 20:05:01 -0700

Login case (black horse) - simple login case using druid database connection pool, JdbcTemplate technology and Servlet

catalog User login case requirements Development steps: 1. Create project, configuration file and import jar package. 2. Write logged in login.html Page. 3. Create the database userlogin and the table user. 4. Create a package com.qgl . 'domain'. Create an entity class user. The entity class user c ...

Posted by irish21 on Sun, 28 Jun 2020 17:55:56 -0700

FreeSql uses ToTreeList/AsTreeCte to query infinite level classification table

On infinite class The first option: Recursion algorithm is also the most frequently used, and most open source programs do the same, but generally only use four levels of classification. The database structure design of this algorithm is the simplest. A field ID and a field FID (parent id) in the category table. In this way, we can judge the up ...

Posted by jwoo on Sat, 27 Jun 2020 17:13:04 -0700

362. Java intermediate 17 - [JDBC] June 27, 2020

0. Directory 1,JDBC 2. Import the jar package of MySQL JDBC for the project 3. Initialize driver 4. Establish a connection to the database 5. Create Statement 6. Execute SQL statement 7. Close connection 8. Use try with resource to automatically close the connection 9. Reference link 1,JDBC JDBC ...

Posted by han2754 on Sat, 27 Jun 2020 02:34:49 -0700

Production environment database backup scheme

1, Introduction After the product goes online, our data is very important. It's not allowed to be lost. We should be well prepared. If one day is hacked or deleted maliciously, it will crash. So we need to do full backup and incremental backup for our online database regularly. For example, make incre ...

Posted by lauxanh on Sat, 27 Jun 2020 01:35:14 -0700

Triggers and views in MySQL

The keyword "delimiter" is used to declare the delimiter of SQL statement and tell mysql interpreter whether the command has ended and whether mysql can be executed. By default, delimiter is a semicolon;. In the command line client, if a line of commands ends with a semicolon, mysql will execu ...

Posted by danielrs1 on Fri, 26 Jun 2020 18:30:09 -0700

SQL Base Notebook 2 View Stored Procedure

  View CREATE/ALTER/DROP VIEW ViewName as SELECT(...) You can continue to create a view based on it, that is, you can place the previously created view as a table name in the select statement of the new view Format data using views (that is, reassemble and stitch fields) CREATE VIEW View_player_team AS SELECT CONCAT(player_name, '(' , t ...

Posted by Izzy1979 on Fri, 26 Jun 2020 09:58:46 -0700