In the previous document, mysql master-slave databases were deployed through docker:
Deploy mysql master-slave architecture in docker mode_ Repair Baron's blog - CSDN blog
This paper introduces how to connect and use mysql master-slave database in java code to realize the separation of reading and writing.
mybatis-plusPersistence layer frame ...
Added by Muddy_Funster on Thu, 10 Mar 2022 07:31:02 +0200
Commodity management system (stored in database)
For the first time, if there is an error in my blog, I can send a private letter. Thank you for your correction.
If you can write, I hope you can pay attention to it, and will continue to update the learning process and make progress together.
The source code is at the end ...
Added by Ind007 on Thu, 10 Mar 2022 06:28:32 +0200
Oracle database dmp to mysql format
The customer of the first project is oracle database, which needs to import a table data to the mysql database of the self research system. Party A has given the dmp file in oracle format! Treatment idea: ① . install Oracle database. ② Import the dmp file in Oracle format provided by Party A i ...
Added by SulleyMonstersInc on Thu, 10 Mar 2022 04:45:39 +0200
Where query and fuzzy query
Function: retrieve qualified values in data
operatorgrammardescribeand &&a and b || a&&bLogic and, both are true, and the result is trueor ||a or b || a || bLogical or, one of which is true, the result is trueNot !not a || !aLogical negation
where statement example
1. Find an inte ...
1.1 index overview
MySQL's official definition of index is: index is a data structure (orderly) that helps MySQL obtain data efficiently. In addition to the data, the database system also maintains the data structure that meets the specific search algorithm. These data structures refer to (point to) the data in some way, so that the ...
Added by milesap on Wed, 09 Mar 2022 14:51:29 +0200
Data table advanced operations
Clone the table and generate the data records of the data table into a new table
Method 1: use like
create table test like info; #Using the LIKE method, copy the KY08 table structure to generate the test01 table
insert into test select * from info;
Method 2: direct cloning
However, direct cloning ca ...
=Horizontal partition (by row according to column attribute)=
Take a simple example: a table containing ten-year invoice records can be divided into ten different partitions, and each partition contains the records of one year.
Mode of horizontal partition:
Range – this mode allows DBA s to divide data into different ranges. For e ...
Added by tobimichigan on Wed, 09 Mar 2022 13:13:19 +0200
When doing data analysis, we often hear the concepts of year-on-year and month on month. When publishing statistical data, enterprises and organizations usually like to compare the previous historical data with the year-on-year and month on month data to illustrate the changes of the data. For example, the Bureau of Statistics announced that in ...
Added by unreal128 on Wed, 09 Mar 2022 07:46:56 +0200
This example is based on Vue JS and mint UI implementation.
1, Creation of database
2, Connection between back-end interface and database
3, Front end code implementation
1. Relevant codes of registration page
2. Effect of registration page
3. Relevant codes of login page
4. Landing page effect
4, Demo login
5, Project fil ...
mysql5.7 minor version upgrade - windows
Application scenario: upgrade mysql 5.7.20 to the latest 5.7.31, Windows Environment
Download link on the official website: https://dev.mysql.com/downloads/mysql/5.7.html
Note: mysql data must be backed up before operation to avoid problems during installation and can be remedied
1, Close and delete ...