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