On the trigger of mysql stored procedure
What is a stored procedure?
That is, you can write logical sql, such as judgment, loop, etc,,
What are the benefits?
Imagine that we want to insert 100 pieces of data. Compared with batch operation, it is sure that the efficiency of the stored procedure is high In addition, the running speed of stored procedures is v ...
Posted by davidsakh on Wed, 15 Apr 2020 09:29:39 -0700
What is the difference between Class.forName and lassLoader?
Preface
Recently, during an interview, I was asked the difference between a Class.forName() loading class and a ClassLoader loading class in the Java reflection.I didn't come up with it at that time. I studied it myself and wrote it down.
explain
Class.forName() and lassLoader can both load classes in java.ClassLoader is a class loader that fol ...
Posted by like_duh44 on Tue, 14 Apr 2020 19:49:52 -0700
Collection again! How can MySQL maintain master-slave synchronization without downtime? This is enough
Preface
In May 17, 2013, after the last IBM small computer of Alibaba group was released from Alipay, there is no doubt that MySQL is already the most widely used database in Internet Co nowadays. Mysql is free and open source, and it can be conveniently extended horizontally to support high concurrency traffic. Small and medium-sized enterpri ...
Posted by zoozle on Tue, 14 Apr 2020 02:23:11 -0700
Use of LocalDateTime in the project (LocalDateTime docking front end interacts with timestamp, LocalDateTime docking database)
Catalog
1. Blog writing background
2. LocalDateTime front-end interaction
2.1 LocalDateTime writes a timestamp to the front end
2.1.1 fastJson default write format
2.1.2 Change the fastJson write format so that it writes back the timestamp ()
2.2 Receive the time stamp passed by the front end as LocalDateTimme
2.2.1 LocalDateTime Default ...
Posted by haddydaddy on Mon, 13 Apr 2020 18:47:43 -0700
linux MySQL installation strategy
1.https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz
Download the installation package.
The previous MySQL installation failed because of the selected version. It is recommended to select [Linux generic]
Decompression:
tar zxvf mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz
//Put the ...
Posted by nariman on Mon, 13 Apr 2020 10:35:50 -0700
Flink's DataSource Trilogy 3: customization
This article is the end of the trilogy of Flink's DataSource. The previous studies are all about Flink's existing data source functions. However, if these cannot meet the needs, you need to customize the data source (such as obtaining data from the database), which is the content of today's actual combat, as shown in the red box below:###Flink' ...
Posted by liebs19 on Mon, 13 Apr 2020 03:26:28 -0700
Best practice of springboot + aop, no longer afraid to double-click 666
Talk nineteen to the dozen
During the crazy overtime work less than a month after returning to work, I haven't had much time to write blog recently, which is a little bit slow. Fortunately, in the projects I do, not all are business logic of addition, deletion and modification, or some more interesting and practical technical points, so I sorte ...
Posted by betportal on Sun, 12 Apr 2020 04:25:05 -0700
Linux system: building PostgreSQL relational database under Centos7
Source code: GitHub point here || GitEE point here
1, Introduction to PostgreSQL
1. Database introduction
PostgreSQL is a powerful open source database system, which has the characteristics of reliability, stability, data consistency, and can run on all major operating systems, including Linux, Unix, Windows, etc. PostgreSQL is a complete tran ...
Posted by MaxBodine on Sat, 11 Apr 2020 21:55:33 -0700
Spring Boot 2.x actual combat -- SQL database (Spring Data JPA)
I am Xiaoxian, a non slash youth who focuses on big data and distributed technology. I love Coding, reading, photography and life more!
Source code warehouse: https://github.com/zhshuixian/learn-spring-boot-2
The previous section mainly introduces Spring Boot integrating Log4j2 and Slf4j to print and output logs to files. In the application d ...
Posted by Sam on Sat, 11 Apr 2020 19:05:16 -0700
I don't know jdbc, what about Mybatis source parsing?
This article is mainly intended to show the use of jdbc to make it easier to read MyBatis source code and to warm up for source analysis.
Many of the key information can be found in the MyBatis source code. This article does not analyze the MyBatis source code.
Because the MyBatis source code is a huge and complex project, it can't be said in j ...
Posted by juma929 on Fri, 10 Apr 2020 21:13:28 -0700