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
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
Date of becom ...
Posted on Fri, 26 Jun 2020 04:08:30 -0400 by TPerez
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
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
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.
Group_can be used directly for merging sp ...
Posted on Wed, 24 Jun 2020 22:09:54 -0400 by zggtf211
1. Mathematical Functions
2. String Functions
2.1 CHAR_LENGTH and LENGTH
2.4 LOWER and UPPER
2.5 LEFT and RIGHT
Posted on Wed, 24 Jun 2020 12:55:28 -0400 by xgab
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
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
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
JDBC core technology
1. Data persistence
2. Data storage technology in Java
3. Introduction to JDBC
4. JDBC architecture
5. JDBC programming steps
2, Get database connection
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