Deployment of self study notes on MySQL 8 official website MGR
Self study notes on MySQL 8 official website Chapter 1 deploying Mgr (MySQL group replication) preface It has been five years since MySQL 8 was launched on September 12, 2016. Its version has become mature and stable, and the industrial upgrading implementation schemes of major factories have bUTF-8...
Posted by pseudonym on Thu, 30 Sep 2021 07:52:05 +0530
Mybatis actual combat: one to many relationship
One background 1.1 examples The company has several employees. At this time, the relationship between the company and its employees belongs to a one to many relationship. Based on the above information, we can create two tables: company information and employee information. The company table fUTF-8...
Posted by gushy on Fri, 01 Oct 2021 02:37:02 +0530
Deploy the SpringBoot project to the server
1, Server environment preparation 1. Install and configure JDK Use FileZilla to upload jdk-8u161-linux-x64.tar.gz to the mnt folder of the server mkdir /opt/modules/ Extract to the new folder tar -xf /tmp/jdk-8u161-linux-x64.tar.gz -C /opt/modules/ Configure environment variables vi /etc/profiUTF-8...
Posted by gandelf1000 on Sat, 02 Oct 2021 03:23:37 +0530
MySQL stored procedure + function
Stored procedures and functions The article has been synchronized to the GitHub open source project: Java supernatural Road variable System variable global variable Session variable View all variables SHOW [GLOBAL/SESSION] VARIVALES Condition query SHOW [GLOBAL/SESSION] LIKE '%char%' View the vUTF-8...
Posted by gls2ro on Sun, 03 Oct 2021 00:40:55 +0530
MYSQL Database SQL Statement Practice Experiments
MYSQL database SQL statement practice experiment (1) 1. Create Employee and Department tables 1.1 First we should open our WAMPSEVER for use, and then we will build two tables, Employee and Department. There are two ways to create our tables. First method: First, we can use our interface to creUTF-8...
Posted by BDKR on Mon, 04 Oct 2021 21:54:17 +0530
Ali Tianchi-SQL Training Camp Learning Notes 1
First Identity Database A Database (DB) is a collection of data that is stored and processed by a computer to be accessed efficiently.Database Management System (DBMS) is a computer system used to manage databasesTypes of database systems Hierarchical_Database (HDB)Relational Database (RDB)ObjUTF-8...
Posted by wipe on Tue, 05 Oct 2021 21:30:35 +0530
10 minutes to learn about mysql
Introduction Benefits of databases 1. Persist data locally 2. Structured queries can be implemented and managed easily Concepts related to databases 1. DB: A database, a container for an organized set of data 2. DBMS: A database management system, also known as a database software (product), uUTF-8...
Posted by Tanus on Wed, 06 Oct 2021 01:23:29 +0530
MYSQL database ---- learning content on October 4
MYSQL database ---- learning content on October 4 Data type of database Integer types can be divided into 5 types: TINYINT, SMALUNT, MEDIUMINT, INT and BIGINT Use floating-point numbers and fixed-point numbers to store decimals in MySQL database. Floating point number types include float and doUTF-8...
Posted by CBG on Wed, 06 Oct 2021 01:26:58 +0530
MYSQL database ---- learning content on October 4
MYSQL database ---- learning content on October 4 Data type of database Integer types can be divided into 5 types: TINYINT, SMALUNT, MEDIUMINT, INT and BIGINT Use floating-point numbers and fixed-point numbers to store decimals in MySQL database. Floating point number types include float and doUTF-8...
Posted by spivey on Wed, 06 Oct 2021 01:32:04 +0530
XIV - database operation
preface In the UserManager program, the storage of data is persisted through files. If there are more types of data and more interactions For example: add Fund - > user buys fund There may be data redundancy 1. Background Data persistence, large amount of data, user demand Database programmingUTF-8...
Posted by hiprakhar on Wed, 06 Oct 2021 06:09:30 +0530