SQL. Page 5

[open source]. Net orm FreeSql 1.5.0 latest version (serial number: long time no see)

The beginning of nonsense This article is the...
1:03 26 May 2020

MHA cluster of MySQL highly available articles

1 preparations 1.1 modify host na...
11:21 25 May 2020

Custom Spring Boot starter

When we use spring boot to develop applications quickly, we often introduce many libraries that start with spring boot s...
8:53 25 May 2020

PHP PDO mysql abstraction layer

Using PDO constructor to connect database and DSN <?php $dbms = 'mysql'; $dbname = 'test'; $user = 'root'; $pwd = '1...
4:04 25 May 2020

The running in period of Flink and Hive

There is a lot of feedback from readers. Please refer to the previous article< Hive is finally waiting, Flink >Whe...
3:57 25 May 2020

fio storage performance manometry

1. Environmental Instructions: This demo is a dellr620 physical server with centos7.6 x86_64-bitThe hardware-related inf...
12:20 24 May 2020

Master the basic Oracle syntax quickly, let you come and go freely

This article, let's continue the previous installation, explain the basic syntax of Oracle, so that you can operate and ...
12:38 22 May 2020

Maven combines JaCoCo Co and Sonar to see if you've written enough tests

1 Introduction Unit testing is an important p...
12:50 20 May 2020

SQL Server 2008 delete large amount of data

1, Write it in the front. - it's not easy to say love you ...
3:59 19 May 2020

Oracle RAC 12.2.0.1 Patch 30920127(Apr 2020)

Oracle RAC 12.2.0.1 Patch 30920127(Apr 2020) ...
12:04 18 May 2020

[Oracle] about database character coding modification

String encoding is not uniform, which will lead to import exceptions, display garbled code and other problems. Here is t...
10:54 18 May 2020

Docker data management and network communication, port mapping

Bibliography: 1. Data management of docker 1. Data Volume...
22:16 16 May 2020

User and Rights Management for MySQL

In MySQL 5.7.24, information about users and user permissions is stored in the user table of mysql library, which can be...
15:40 16 May 2020

Failure handling of Oracle database startup report ORA-00600 [kkdlcob-objn-exists]

*Author's introduction*****Original Creator: Lose SeriouslyContact number: 18081072613WeChat, QQ:18081072613Reprint to i...
15:17 16 May 2020

MySQL query duplicate data

Suppose there is a user table, user. The data is as follows: ...
11:25 16 May 2020

Stored procedure - exception capture & printing exception information

catalog 0. Background 1. Create the exception information table ErrorLog 2. Establish a stored procedure to save except...
21:17 13 May 2020

Talk about debezium's snapshot change record emitter

order This paper mainly studies the snapshot ...
12:03 13 May 2020

The difference between [MySQL] char and varchar

CHAR and VARCHAR types are similar, but they are saved and retrieved in different ways. Their maximum length and whether...
11:29 12 May 2020

Mysql dual host hot standby and implementation of Mysql dual host and high availability with preserved

There are two ways of mysql hot standby: Hot standby of m...
5:17 11 May 2020

Analysis of Hadoop YARN ResourceManager crash caused by data limit of ZooKeeper node

This problem makes us encounter again. It happens infrequently, but once it happens, it will cause resource manager serv...
10:38 10 May 2020

Python 3 automated file batch processing (text, PDF; read, filter, export)

With the concise syntax of Python 3 script language and the rich class library of advanced language, several "scrip...
10:04 8 May 2020

(Reprint) SpringData JPA advanced - JPA one to many, many to many

Link: https://blog.csdn.net/qq_36662478/article/details/89111437 Primary key generation strategy in JPA   &e...
6:01 8 May 2020

Logging user login information using init_connect parameter

Note: The content of the article originated from the Internet and was based on our own experiments; however, the address...
16:15 7 May 2020

docker mysql8 master-slave configuration

The mysql of this pull is version 8, which is used to build master-slave replication ...
1:17 7 May 2020

Basic use of JdbcTemplate

brief introduction JdbcTemplate is Spring's e...
11:15 6 May 2020

Solve 1032 error report of online master-slave replication

The reason for the error is that the master database service is restarted abnormally, which causes the slave database re...
10:09 6 May 2020

Data Source Management | Synchronize data and source analysis based on DataX components

Source code for this article: GitHub. Click here || GitEE. Click here 1. Introduction to DataX Tools ...
20:13 5 May 2020

MySql basic instructions

1. Start MySql /etc/init.d/mysql start Run successfully: ...
19:45 5 May 2020

Instructions for mysql5.7 General tablespace

Note: the content of the article originated from the network and was obtained through our own experiment; however, the r...
15:22 5 May 2020

Oracle (PLSQL) introduction 7

Learning video: https://www.bilibili.com/video/BV1tJ411r7EC?p=74 Design database steps: Good database design: save space...
13:48 5 May 2020