javaEE(SSM)-4: dynamic SQL

title: javaEE(SSM) learning notes 4: dynamic SQL Dynamic SQL import [main function]: splice SQL clauses according to different conditions or different data to achieve similar programming effect in XML files. [main element (mark)]: Query criteria: single branch if; Multi branch choose... when... other Special treatment: where /trim Up ...

Added by Benjigga on Thu, 10 Mar 2022 18:34:12 +0200

Using MySQL Router to build read-write separated MGR cluster

The original content of GreatSQL community cannot be used without authorization. Please contact Xiaobian and indicate the source for reprint.[toc]This paper introduces how to deploy MySQL Router in the front end of MGR cluster to realize read-write separation, read load balancing and automatic failover.MySQL Router is a lightweight middleware. ...

Added by danbot26 on Wed, 09 Mar 2022 04:04:29 +0200

Hive window function Over partition by

-Catalogue 1. Aggregate function + over2. partition by clause3. order by clause4. ★ window clause (included) - predicting: forward - FOLLOWING: backward - CURRENT ROW: CURRENT ROW - UNBOUNDED: starting point5. ★ sequence function in window function: including NTILE(n), row_number,rank,dense_rank   brief introduction The hive function in this ...

Added by BigTime on Tue, 08 Mar 2022 23:46:16 +0200

MySQL advanced 1 -- constraints

1. Restraint 1.1 concept Constraints are rules that act on columns in a table and are used to restrict the data added to the table For example, we can restrict the id column so that its value cannot be repeated and cannot be null. The existence of constraints ensures the correctness, effectiveness and integrity of data in the database Addin ...

Added by iRock on Tue, 08 Mar 2022 17:40:06 +0200

Basic usage of oracle Database: annotation, sequence, view and index

1. Sequence summary A sequence is a database object that helps tables to create automatically growing primary keys. Sequence is an object held in oracle database, which is not available in other databases. establish Default syntax for creating sequences create sequence Sequence name; Much like creating a table The full amount is cr ...

Added by jdeer0618 on Tue, 08 Mar 2022 06:09:20 +0200

sql practical optimization and misunderstanding

sql common pit + optimization How many of the eight common SQL misuses did you get? Alibaba cloud RDS expert delegation Java 2022-02-28 09:09 Introduction: Alibaba cloud RDS expert service team has helped cloud customers solve many urgent problems. Some common SQL problems in ApsaraDB expert diagnosis report are summarized as follows for your ...

Added by ashutosh.titan on Mon, 07 Mar 2022 11:31:39 +0200

HTML learning notes

HTML 1: Basic cognition Understanding web pages 1: What is a web page Text, pictures, audio, video and hyperlinks 2: What is the essence behind the web page Front end code 3: What is the code transformed into an interface Browser parsing and rendering Five browsers 1: Browser It is the platform for web page display and operation 2: ...

Added by roshanjameer on Sun, 06 Mar 2022 15:06:05 +0200

Examples of thread safety problems and solutions (ReentrantLock)

1. Preface This article is a follow-up to the previous article. The case is the same case. It is very simple. It is the case of taking the order number when going to teacher Tian for dinner. Without too much introduction, you can also see the detailed introduction of the previous article, as follows:1.1 synchronized solves thread safety pr ...

Added by pixeltrace on Sat, 05 Mar 2022 13:59:13 +0200

[must see] this article is enough for a complete collection of SQL statements

SQL, namely structured query language, is a database query and programming language, which is used to access data and query, update and manage relational database system; SQL language is the widely used standard language of relational database and the basis of various database interaction methods. The following will show how to use SQL to acces ...

Added by cmaclennan on Sat, 05 Mar 2022 12:31:30 +0200

MySQL basics -- DQL

1, Introduction Query specification Each command is in; Or \ g or \ g endIt is recommended to use single quotation marks' 'for string type and date time type data, and double quotation marks'' for column alias, and omitting AS is not recommended Annotation specification Single line annotation: # annotation text (MySQL specific method)Si ...

Added by tet3828 on Fri, 04 Mar 2022 10:47:27 +0200