Some useful SQL statements in MySQL
When writing SQL, we often flexibly use some skills of SQL statement writing, which can greatly simplify the program log...
Spark_ Correct use of checkpoint in spark and its difference from cache
1.Spark performance tuning: use of checkPoint
https://blo...
druid monitor configuration -- springBoot project
Cause: one day, my colleague's project connection pool burst
...
JPA multi data source distributed transaction processing: two transaction schemes
preface
Transaction processing of multiple da...
Flink Sql on Zeppelin -- environment preparation
Environmental preparation summary Why Sql At present, there are many ways to develop Flink. Generally speaking, stud...
MongoDB Quick Start, that's all right!
SpringBoot e-commerce project mall (30k+star) address: https://github.com/macrozheng/mall
...
Simple configuration of mysql database master-slave synchronization, read-write separation
This paper is learning notes, mainly used to record my learning process. Part of the content for reprint!!!!
...
Where PL/SQL stored procedures can go wrong with IDEA use [High energy ahead!]
Stored procedures in PL/SQL combined with IDEA
...
Understand MYSQL in one day
MySQL learning notes Installation tutorial: https://www.runoob.com/mysql/mysql-install.html Install video: https://www.b...
Summary of Java Concurrent Programming Practice
premise
First, the scene is a hotel-based bus...
JEECG containerization deployment
There is a Dockerfile in the JEECG code. The basic idea is to take CentOS as the basic image, in which nginx, jdk, MySQL and redis are installed. The...
Beginner's understanding of Java design pattern
The structural pattern of Java design pattern 1. Adapter mode Adapter mode of class 1.1 1.2 adapter mode for objects 1...
ORM Framework Series of Wheelmaking Motion~Talk about ORM Framework in my mind
ORM Conceptual Analysis
First, comb out the c...
Thread factory of the nine Yin scriptures of C + +
The previous article ended the implementation of thread factory class, which mainly introduces the use of thread factory...
type column parsing of explain
1,const Indicates that the execution step returns at most one row of data. const usually appears in the equivalent query...
Summary of JDBC basic knowledge
Refer to the summary of Java language programming foundation version 10
...
Access to byte stream of sqlite byte array
There are two ways to store sqlite byte arrays: It's easy to understand how to store byte array in string type Base64...
Access to byte stream of sqlite byte array
There are two ways to store sqlite byte arrays: It's easy to understand how to store byte array in string type Base64...
The modified character set code of MySQL 5.6 under Linux is UTF8 (to solve the problem of Chinese code scrambling, it can be used for personal test!)
The modified character set code of MySQL 5.6 under Linux is UTF8 (to solve the problem of Chinese scrambling) 1, Log in ...
How to store IP address effectively in MySQL
A few days ago, a friend of a Miao went for an interview. He came back and told me that the interviewer asked him how hi...
How to use Apache Flink to query Pulsar flow
In the previous blog, we introduced Apache Pulsar and its differences from other message systems, and explained how to i...
ES7 learning notes GEO location search
The basic content of ES is almost introduced. At last, let's take a look at GEO location search. Now most apps have loca...
C ා data operation series - Introduction to 19 FreeSql
0. Preface
The author of FreeSql recommended...
All MySQL installation and deployment methods
catalog 1, Foreword 2, About MySQL installation 3, Deployment planning 3.1 server planning 3.2 database directory plan...
Centos7 MySQL installation master-slave replication configuration
Installation Dependency yum search libaio # Retrieving related information yum install libaio # Install Dependent Packag...
PHP regular expression details how to extract characters between two strings (supports single & multiple)
preface:
Sometimes it is necessary to extract...
[12c] DataGuard builds physical standby database (Cloud Control mode)
How to Building physical standby database by RMAN Duplicate , this article will demonstrate how to use Cloud Control to ...
A reusable distributed transaction message architecture based on RabbitMQ
premise
Distributed transaction is a more dif...