Installing Mysql on Linux

Reference article: Installing mysql on linux_ Stupid food first fly blog - CSDN blog_ Installing mysql on linux Modify password reference article: What if mysql forgets the password under linux - big no - blog Garden To install Mysql: centos7 MySQL installation (full version)_ Programmer's advanced road - CSDN blog_ Installing MySQL in CentOS ...

Posted by dsp77 on Sat, 18 Sep 2021 07:59:00 +0200

Basic use of MySQL (addition, deletion, modification and query)

catalogue 1, Advantages 2, Create databases and tables 3, Basic usage syntax (addition, deletion, modification and query)   1. Increase 2. Delete 3. Change 4. Check 1, Advantages Simple: compared with other large databases, MySQL is a relatively simple database system, which is easier to use than XiaobaiEconomy: compared with s ...

Posted by izlik on Sat, 18 Sep 2021 05:57:06 +0200

Spring -- JDBC and transaction 2021-09-16

JDBC 1. Functions of JDBC module: Responsible for database resource management and error management, which simplifies the operation of developers on the database. 2,JdbcTemplate: The Spring framework provides this class, which is the basis of the data abstraction layer of the Spring framework and the core class of Spring JDBC. 3. The JDBC ...

Posted by fredouille on Fri, 17 Sep 2021 05:25:54 +0200

MySQL Multiple Table Query Exercise

One: Preparing data #Create tables and insert records CREATE TABLE class ( cid int(11) NOT NULL AUTO_INCREMENT, caption varchar(32) NOT NULL, PRIMARY KEY (cid) ) ENGINE=InnoDB CHARSET=utf8; INSERT INTO class VALUES (1, 'Class Two, Three Years'), (2, 'Three-year shift'), (3, 'Class Two a Year'), (4, 'Nine Classes in Two Years'); CREA ...

Posted by bhinkel on Thu, 16 Sep 2021 20:54:59 +0200

Docker Container Data Volume Details

1.Data Volume Introduction Docker packages and runs environments to form container runs. Data generated by Docker containers will naturally be lost when the containers are deleted unless a new image is generated through docker commit. In order to save data in Docker we use volumes. | Volumes are directories or files that exist in one or more ...

Posted by Moonspell on Sun, 12 Sep 2021 19:05:21 +0200

SQL statement basic exercise (table creation, basic query) - Provide table building statements and query topics and answers

Explain The difficulty of the basic exercises is fairly simple, but there are still some details to master. The main purpose of this topic is to familiarize yourself with the basic queries of SQL statements, so you can understand the statements about table building, because in general development, tables are built graphically, while SQL sta ...

Posted by jjfletch on Tue, 07 Sep 2021 23:40:42 +0200

Multi data source configuration Jpa

Twenty eight good people are like crisp people. They cut fools with swords at their waist. Although I don't see my head falling, I secretly teach you that your bone marrow is withered. The previous chapter briefly introduced how to configure the jdbctemplate for multiple data sources (15). If you haven't seen it, Please watch the previous ch ...

Posted by atlanta on Tue, 07 Sep 2021 01:58:19 +0200

MHA High Availability Configuration and Failover

Catalog 1. Understanding MHA 1. Overview of MHA 2. Composition of MHA 3. Characteristics of MHA 4.MHA cluster architecture diagram  2. Build MySQL MHA 1. Construction of MHA 2. Fault simulation  Algorithms for failover alternate primary libraries: Failure Repair Steps: 1. Understanding MHA 1. Overview of MHA MHA (Mast ...

Posted by XiaoRulez on Mon, 06 Sep 2021 18:54:03 +0200

Berserker says Mybatis notes

Crazy God said MyBatis01: the first program Introduction to MyBatis Environmental description: jdk 8 +MySQL 5.7.19maven-3.6.1IDEA Before learning, you need to master: JDBCMySQL Java Foundation MavenJunit What is MyBatis MyBatis is an excellent persistence layer frameworkMyBatis avoids almost all JDBC code and the proce ...

Posted by jeephp on Thu, 02 Sep 2021 20:47:51 +0200

SpringBoot implements multiple data source configuration

Spring boot for multi data source configuration springBoot implements the configuration of multiple data sources application.properties Configure two data sources in spring.datasource.primary.url=jdbc:mysql://localhost:3306/test1 spring.datasource.primary.username=root spring.datasource.primary.password=root spring.datasource.primary.driv ...

Posted by AtomicRax on Mon, 20 Jul 2020 18:01:36 +0200