MySQL 8.0 window function practice and summary

Before MySQL 8.0, it was quite painful to do data ranking statistics, because there was no window function like Oracle, SQL SERVER, PostgreSQL and other databases. However, with the addition of window functions in MySQL 8.0, it is no longer a problem for this kind of statistics. This paper introduces MySQL window functions with common sorting e ...

Posted on Sat, 27 Jun 2020 03:42:25 -0400 by always_confused

Introduction to Mysql built-in functions (including a large number of examples)

The following is a summary of a Li's learning of MySQL built-in functions, hoping to help you; if you don't know mysql, you can read another blog of a Li first mysql Foundation 1: Date function 2: String function 1: Date function Function name describe current_date() Date of becom ...

Posted on Fri, 26 Jun 2020 04:08:30 -0400 by TPerez

My little goal

Made a project, maven+IDEA+MySQL Because of frequent computer crashes and other reasons, I put it in my blog, share it, and record the process and problems I met. Whether I can grow up or not depends on the response of the caretaker. Every place with a yellow background is the pit I met. Title creat ...

Posted on Fri, 26 Jun 2020 02:24:51 -0400 by rharden

Beego Learning Notes 14:Session Control

Session Control 1> Session s are often used as global variables, such as logging the currently logged-in user or passing data between pages. 2> The session module is built in the Beego framework. Currently, the session module supports back-end engines including memory, cookie s, file s, mysql, redis, couchbase, memcache, postgres. Users c ...

Posted on Thu, 25 Jun 2020 12:20:31 -0400 by JetJagger

MySQL merges and splits by specified characters

Merging or splitting by specified characters is a common scenario. MySQL is easier to write in merged characters, but splitting by specified characters is more cumbersome (that is, writing more characters).This article will show examples of merging and splitting by specified characters. 1. Consolidation Group_can be used directly for merging sp ...

Posted on Wed, 24 Jun 2020 22:09:54 -0400 by zggtf211

SQL Mathematical Functions, String Functions for Programmers

Article Directory Preface 1. Mathematical Functions 1.1 ABS 1.2 CEIL 1.3 FLOOR 1.4 MOD 1.5 RAND 1.6 ROUND 1.7 TRUNCATE 1.8 POW 2. String Functions 2.1 CHAR_LENGTH and LENGTH 2.2 CONCAT 2.3 INSERT 2.4 LOWER and UPPER 2.5 LEFT and RIGHT 2.6 REPLACE 2.7 TRIM 2.8 SUBSTRING 2.9 LOCATE,POSITION,INSTR 2. ...

Posted on Wed, 24 Jun 2020 12:55:28 -0400 by xgab

MySQL master-slave replication building (one master and two slaves)

1, Environment introduction The data replication between MySQL is based on binary log files. Once the binary log is enabled in MySQL database, all operations in its database will be recorded in the binary log in the form of events as Master. Other databases as Slave will keep communication with the Ma ...

Posted on Wed, 24 Jun 2020 02:45:40 -0400 by Wetzut

Spring Boot declarative transaction management example

Video Explanation address: (reserved: to be uploaded...)Let's start: What is a database transaction? A database transaction is a single logical unit of work that accesses and potentially modifies the contents of a database.Let's check the mysql database: Open two separate windows for mysql database In a mysql window, create a database ...

Posted on Wed, 24 Jun 2020 01:17:33 -0400 by CaptainChainsaw

Technology sharing, semi consistent reading and optimization of Update

Author: Zhao Liming Aikesheng, a member of MySQL DBA team, Oracle 10g OCM, MySQL 5.7 OCP, is good at database performance problem diagnosis, transaction and lock problem analysis, and is responsible for dealing with the problems in the daily operation and maintenance of customer MySQL and our company's self-developed DMP platform, and is very ...

Posted on Tue, 23 Jun 2020 06:07:02 -0400 by ultraviolet_998

Java, JDBC core technology, transaction, thread pool

Article catalog JDBC core technology 1, Overview 1. Data persistence 2. Data storage technology in Java 3. Introduction to JDBC 4. JDBC architecture 5. JDBC programming steps 2, Get database connection 3, PrepareStatement 1. Operation and access to database 2. Disadvantages of using Statement to ...

Posted on Tue, 23 Jun 2020 03:15:26 -0400 by Chris-the dude