docker network mode
catalogue
1, docker network
1. Network pattern classification
2. Command
How to transfer files from the host to the container
There is no systemctl command solution entering the container
2, docker data volume
Mount data volume
Data volume container
3, Container interconnection (using centos image)
summary
docker mainly has four netw ...
Posted on Mon, 29 Nov 2021 03:44:27 -0500 by Mew151
SQL Server Database -- creation and use of stored procedures
1, Stored procedure
1. Stored procedure
Stored procedure is a set of SQL statements to complete specific functions. It is compiled and stored in the server-side database. Users execute it by specifying the name of the stored procedure and giving parameters (if the stored procedure has paramete ...
Posted on Sun, 28 Nov 2021 22:43:57 -0500 by BigMike
Mybatis source code - load mapping file and dynamic agent
prefaceThis article will analyze how Mybatis parses the SQL statements in the mapping file and how each SQL statement is associated with the methods of the mapping interface during the loading of the configuration file. Before looking at the source code of this part, you need to have relevant knowledge of JDK dynamic agent. If you don't know mu ...
Posted on Sun, 28 Nov 2021 22:44:45 -0500 by rickmans
[advanced MySQL database] two major queries of interview questions (aggregate query and joint query)
Advanced MySQL
1, Aggregate query
The functions and usage used in aggregate query are very similar to that of Excel. If you play NB in Excel, you can basically combine query, which is very easy. 😁😁🤗🤗
Aggregate query is related to rows. Merging query results according to row dimensions means merging multiple rows.
1.1 aggregate funct ...
Posted on Sun, 28 Nov 2021 09:42:39 -0500 by KCKTechs
The differences between hive query statement and mysql
These are the two tables emp and Dept often used in online database examples. The first is dept and the second is emp
For ease of viewing, I added the field name of each column to it
1.hive does not support some sub queries
For example, this topic: query the names of employees with higher wages than SMITH
mysql can end ...
Posted on Sun, 28 Nov 2021 08:59:54 -0500 by mikes127
CentOS 8.5 installing Oracle 19c
This article installs Oracle 19c for Centos8
1, Update yum source (under root user)
Before installing, it is recommended to update the yum source: yum update -y Or dnf update
2, Installation related dependencies (under root user)
yum install -y binutils* compat-libstdc* elfutils-libelf* gcc* glibc* ksh* libaio* libgcc* libstdc* make* syssta ...
Posted on Sun, 28 Nov 2021 04:23:15 -0500 by JParishy
Transaction and index
affair
Either all succeed or all fail
Transaction principle: ACID principle, atomicity, consistency, isolation, persistence (dirty read, phantom read...)
1. Basic concepts
Atomicity
Either all succeed or all fail
Consistency
The data integrity before and after the transaction shall be consistent
Isolation
Transaction isolation is ...
Posted on Sat, 27 Nov 2021 21:23:21 -0500 by Blissey
Mysql Uninstall and Install
1. Mysql Uninstall
Reference connection: https://blog.csdn.net/qq_41140741/article/details/81489531
Shortcut win+r Enter regedit to enter the registry and find HKEY_ LOCAL_ MACHINESYSTEMControlSet001ServicesEventlogApplication\MySQL Folder Delete
Delete HKEY_ LOCAL_ MACHINESYSTEM\ControlSet002ServicesEventlogApplication\MySQL f ...
Posted on Sat, 27 Nov 2021 13:32:31 -0500 by krupapatel
try-catch-finally is easy to understand by byte code
Hello, I'm Architect Jun, an architect who writes code and poems. Today, let's talk about try-catch-finally by byte code. I hope you can help everyone improve!!!
scene
For the following code:
public int test() { int x; try { x = 1; return x; } catch (Exception e) { x = 2; return x; } finally { x = 3; } }
Just hear the voice of Architecture ...
Posted on Sat, 27 Nov 2021 13:05:35 -0500 by katie77
Database foundation
database
Database refers to an organized and shareable data set stored in the computer for a long time. In short, a database is a place to store data. However, its storage method has specific rules. This makes it easy to process data. Database operations include creating and deleting databases. These operations are the basis of database manage ...
Posted on Fri, 26 Nov 2021 17:56:21 -0500 by BizBoy