Advanced mapping: one-to-one, one-to-many, multi-to-many query summary
Data Interaction between Multiple Tables
In fact, one-to-one and one-to-many mappings have already been touched on in the previous configuration. I explained directly in the log because I wanted to write a summary log (that is, this article) after that to summarize the configuration of these advance ...
Posted by trube on Mon, 12 Aug 2019 10:15:14 +0200
Several ways to prevent SQL injection
Original Link: https://blog.csdn.net/justlpf/article/details/99288104
Introduction to SQL Injection
SQL injection is one of the more common ways of network attack. It does not use the BUG of the operating system to implement the attack, ...
Posted by Gasolene on Mon, 12 Aug 2019 04:09:21 +0200
Flink SQL Function Decryption Series: Skills and Thoughts on Data Reduplication
Links to the original text: https://yq.aliyun.com/articles/457356?spm=a2c4e.11163080.searchblog.121.3e542ec1eFQaFJ
Summary
Deduplication logic is widely used in business processing, which can be roughly divided into two categories ...
Posted by tranzparency on Fri, 09 Aug 2019 14:29:41 +0200
JDBC (Tool Class, CRUD, Dao Mode, PrepareStatement)
JDBC
JAVA Database Connectivity Java database connection
To put it bluntly: JDBC is a kind of database access rules and specifications provided by Sun Company. Because there are many kinds of databases and the java language is widely used, Sun provides a specification for other database providers to i ...
Posted by justin.nethers on Fri, 09 Aug 2019 12:17:30 +0200
MySQL 5.7 Database Application Management Practice
1. Modify the prompt of mysql database
1.1 Temporarily modify the mysql login prompt, which expires after the session ends
mysql> prompt \u@\h [\d] \r:\m:\s->
PROMPT set to '\u@\h [\d] \r:\m:\s->'
root@localhost [(none)] 09:18:10->\q
1.2 Permanent modification of mysql login prompt
In my.cnf configuration file, [mysql] module add ...
Posted by thecard on Thu, 08 Aug 2019 11:14:51 +0200
Deploy SubText on GoDaddy
Original Link: http://www.cnblogs.com/jinweijie/archive/2009/09/11/deploy_subtext_on_godaddy.html
Introduction: I used a virtual host called Maritime Interconnection The company provides, there are several problems in half a yea ...
Posted by arkleyjoe on Thu, 08 Aug 2019 08:11:38 +0200
Bilog and relay log cleaning in MySQL
1. Bilog cleaning of MySQL server
1.1 Using MySQL parameter control
expire_logs_days
Setting the expiration date of binary log, the log after the specified number of days will be deleted automatically and can be modified dynamically.
If a non-zero value is set, binlog file s that exceed the defined number of days may be cleaned up when mysqld ...
Posted by elacdude on Wed, 07 Aug 2019 15:30:07 +0200
MySQL_Server_8.0.17_Environment Setup_Basic Knowledge
MySQL download, install, configure:
1.1 Download Address: https://dev.mysql.com/downloads/mysql/1.2 Unzip, Configuration File: Unzip to the C disk'web'folder.
Add the configuration file "my.ini" under the mysql-8.0.17 folder:
[client]
# Setting the default character set for mysql client
defa ...
Posted by Jeff4507 on Wed, 07 Aug 2019 14:19:49 +0200
Detailed usage of SQLite
Strongly Recommend Articles: Welcome to CollectionAndroid Dry Goods Sharing
Read for five minutes, ten o'clock a day, and study with you for life. Here's Android, a programmer.
This article mainly introduces some knowledge points in Android development. By reading this article, you will gain the following contents:
Inheriting SQLiteOpenHelp ...
Posted by lillyapps on Tue, 06 Aug 2019 11:27:59 +0200
Cascade replication of database
Environmental Science:
192.168.205.17: as master server
192.168.205.27: as middle server
192.168.205.37: as slave server
Edition:
OS: centos 7 1810 with mini install
mariadb-5.5.60
Purpose:
If there may be a master server and a read server in the production environment, and there may be multiple slave servers, but the performance of th ...
Posted by subasi on Mon, 05 Aug 2019 13:13:55 +0200