Programmer Group

192.168.80.51Main db01192.168.80.11From web04192.168.80.9From web03 1. Cluster preparation To realize master-slave, please back up the data first First, a single node redis has been installed Single node installation https://blog.csdn.net/ncnhhm/article/details/121443981 Master node profile daemonize yes bind 192.168.80.51 port ...

  preface This article will explain the offset analysis function + over() through an example 1, Concept of offset analysis function lag(col,n,default): used to count the value of the nth row up in the group. The first parameter is the column nameThe second parameter is the nth line up (optional, not filled in, default to 1)The third ...

New bee mall project notes 1. Start the project and access the api online documentation http://localhost:8080/swagger-ui.html [the external chain image transfer fails. The source station may have an anti-theft chain mechanism. It is recommended to save the image and upload it directly (img-ge9fugsh-163811491017) (C: \ users \ Chen \ appdata ...

The second day Preparing data CREATE TABLE student ( id int, -- number name varchar(20), -- Full name age int, -- Age sex varchar(5), -- Gender address varchar(100), -- address math int, -- Mathematics english int -- English ); INSERT INTO student(id,NAME,age,sex,address,math,english) VALUES (1,'Jack Ma',55,'ma ...

summary This article mainly uses the Navicat for MySQL tool to analyze the common constraints of the SQL language through programming and code testing: primary key constraints   And foreign key constraints. Each table in the business needs to have one and only one primary key. There can be multiple foreign keys in a table, but ...

1, Short answer 1. Briefly describe the MySQL version used by your company, and specify the specific minor version and GA time? 5.6.38 5.7.20 2017-9-13 2. Please introduce the type of database you are familiar with and the representative product name? NoSQL:Redis Mongodb memcache RDBMS:Oracle MySQL MSSQL PG 3. Please briefly describ ...

1. Scenario Display Regular expressions and corresponding functions are the same in oracle and mysql. Introduction to regular expression symbols: '^' Matches the start position of the input string, used in a square bracket expression, where it indicates that the character set is not accepted. '$' Matches the end of the input string. If set Re ...

Data definition The main function of DDL is to define database objects (such as database, data table, view, index, etc.). DATABASE (DATABASE) --Create database CREATE DATABASE test; --Delete database DROP DATABASE test; --Select database USE test; Data TABLE (TABLE) --Create data table --Normal creation CREATE TABLE user ( id int(10) ...

This paper introduces how to use Canal to realize asynchronous and decoupled architecture. Later, I will write an article to analyze the principle and source code of Canal.Introduction to CanalCanal is a middleware used to obtain database changes.Disguise yourself as a MySQL slave database, pull the main database binlog, analyze and process it. ...

Addition, deletion and modification of data processing 1, Insert data 1.1 practical problems Solution: use the INSERT statement to INSERT data into the table. 1.2 mode 1: add VALUES Using this syntax, only one piece of data can be inserted into the table at a time. Case 1: insert data in the default order for all fields of the table ...