MySQL - high-level statements (including permutation, median, accumulation, percentage, regularity, stored procedure, etc.)
4, Some data processing methods
create table Total_Sales (Name char(10),Sales int(5));
insert into Total_Sales values ('zhangsan',10);
insert into Total_Sales values ('lisi',15);
insert into Total_Sales values ('wangwu',20);
insert into Total_Sales values ('zhaoliu',40);
insert into Total_Sales values ('sunqi',50);
insert into Total_Sales ...
Added by php-pendejo on Fri, 03 Sep 2021 05:32:27 +0300
MySQL basic review
6. Services
Transaction is to execute a group of SQL statements in the same batch.
ACID principle:
Atomicity
All operations in the whole transaction are either completed or not completed. It is impossible to stagnate in an intermediate link. If an error occurs during the execution of a transaction, it will be rolled back to the state before ...
Added by walexman on Wed, 01 Sep 2021 21:12:27 +0300
Beego Learning Notes 6: Paging Implementation
Implement Paging
1> Business logic for paging implementation
1->N data are displayed on each page. For the total number of data records M, the number of pages M%N==0?M/N:M/N+1;
2->Page Rendering Paging html Part
3>Switch pages, input parameters, background processing, and retrieve new eligible data
4>Paging method, js paging, and ...
Added by whare on Sun, 19 Jul 2020 17:37:26 +0300
docker creates lnmp image
Docker is a lightweight virtualization technology, and lnmp is a powerful, open-source web running environment, so here's a demonstration of using Docker to build an lnmp image.
PS: To maintain lightweight and scalable performance, Docker encourages us to "one process per person"Container"means don't integrate too many functions ...
Added by madrazel on Fri, 17 Jul 2020 17:54:47 +0300
Spring Boot Tutorial 4: Using Druid and Monitoring Configuration
Druid is the best database connection pool in the Java language and provides powerful monitoring and extension capabilities.
After comparing Druid with HikariCP, although HikariCP has a higher performance than Druid, Druid includes many dimensions of statistical and analytical functions, which is why everyone chooses t ...
Added by cwarn23 on Sat, 04 Jul 2020 18:32:49 +0300
Introduction to spring boot project
Recently, I watched a lot of spring boot teaching videos. I felt they were too long, and there was no actual combat of the project. Today, according to a blogger to write a simple user system to add, delete, modify and check, the source code can refer to the second issue of the article. This project use ...
Added by ecco on Sun, 28 Jun 2020 08:52:33 +0300
Modify MySql/MariaDB password
Modify MySqlMariaDB password
Change Password
Modify the original password as soon as you know it
1 Use the SET PASSWORD command to change the password
2 UPDATE Command Modify Password
3 mysqladim change password
2 Forget the original password to modify
Modify MySql/MariaDB password
Change Passwor ...
Added by mike760534211 on Sat, 27 Jun 2020 19:43:37 +0300
Five minute experience of distributed transaction framework Seata
seata is an open source distributed transaction solution dedicated to providing high-performance and easy-to-use distributed transaction services. seata will provide users with AT, TCC, SAGA and XA transaction modes, and build a one-stop distributed solution for users. The purpose of this tutorial is to provide a quick start to the case of seat ...
Added by Cogen on Thu, 25 Jun 2020 07:25:46 +0300
Android interacts with background databases via the Web
Update 2020.06.23
1 Background
Develop an app to interact with the background database, based on MySQL+native JDBC+Tomcat, without using DBUtils or JDBC framework, pure underlying JDBC implementation.In the future, we will gradually change to the Spring framework, optimize MySQL, further deploy Tomcat and so on. Now the project is just startin ...
Added by _will on Tue, 23 Jun 2020 20:10:09 +0300
SSRF uses gopher to attack mysql and Intranet
SSRF uses Gopher
0X01 foreword
After studying the application of Gopher protocol for one day, I decided to write a summary about the SSRF utilization of Gopher protocol.
Reference link: https://blog.csdn.net/qq_41107295/article/details/103026470
0X02 overview
SSRF (server side request forgery) se ...
Added by dipenmistry on Tue, 23 Jun 2020 08:03:47 +0300