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