mysql non recursively queries all hierarchical sub nodes under some nodes

In the past, functions were used to write recursion and find_in_set() to query all the sub nodes under a certain node. Because there is not much business data this time, we tried to use one sql to realize all the sub nodes under N nodes, or to query the path of a node in the tree. Table data: id tree_name parent_id le ...

Posted on Thu, 02 Jan 2020 07:06:04 -0800 by Kev0121

Summary of MySQL 5.7 (json type)

Recently, we know that mysql has added a new field type: json since version 5.7 So a 5.7 version is installed on CentOS 6.5 for normal test #----------------------------------------------------------------------# # Modify yum source to aliyun # Backup first: mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.backup # Dow ...

Posted on Thu, 02 Jan 2020 04:56:56 -0800 by Gmunky

Figure WildFly8.x configuring JNDI data sources

Figure WildFly8.x configuring JNDI data sources There are two configuration modes, one is to set in jboss XML configuration file, the other is to set graphical interface in jboss management background. The essence of graphical interface setting is to set XML configuration file. The interface setting is as follows: Then set t ...

Posted on Wed, 01 Jan 2020 21:38:18 -0800 by gunabalans

How to track user operation (add, delete and change) records in MySql

Sometimes, we want to track a database operation record, such as to find out who operated a table (such as who changed the field name). Binary log records operation record, thread number and other information, but it does not record user information, so it needs to be combined with init connect to achieve tracking. Init conne ...

Posted on Wed, 01 Jan 2020 20:40:14 -0800 by lc21

Self study notes of MySQL database language 5: time functions of common functions

Sometimes we will encounter a similar scenario: "statistics of the total income of the two working days before today". These requirements need to be implemented through date and time functions. curdate() returns the current date in the format of mm / DD / yyyy, curtime() returns the current time in the format of min ...

Posted on Wed, 01 Jan 2020 18:42:34 -0800 by igorlopez

How to install MYSQL of the community version of blue whale smart cloud v3.1.7?

How to install MYSQL of the community version of blue whale smart cloud v3.1.7? Install "blue whale smart cloud" Community Edition - record - install MYSQL of blue whale smart cloud Q. Prerequisite knowledge: Experimental machine: centos7 bkce_src-3.1.7.tgz community version In "Haoding king 5: operation ...

Posted on Wed, 01 Jan 2020 14:35:42 -0800 by golles

Linux Installation mysql5.7.20 database tutorial

Linux Installation mysql5.7.20 database tutorial Installation environment and software version: System: Centos6.8 Database version: mysql-5.7.20-linux-glibc2.12-x86 ʄ CPU: 2 Hard disk: 100G Memory: 2G Installation steps 1. Upload the installation package mysql-5.7.20-linux-glibc2.1 ...

Posted on Wed, 01 Jan 2020 11:39:51 -0800 by AnotherQuestion

Configuration method of Druid connection pool (mysql version)

Mysql connection pool configuration method First, download two packages and import them into bin Baidu online disk link, password: n3en Create a File file with suffix: properties in src of Java Web project, and write the following code in the File page: username=root password=123456 maxActive=100 maxWait=10000 maxIdle=1 ur ...

Posted on Wed, 01 Jan 2020 10:20:05 -0800 by lehara

Deploy zabbix enterprise level monitoring

Introduction: zabbix is an enterprise level open source solution based on WEB interface, which provides distributed system monitoring and network monitoring functions. zabbix can monitor various network parameters to ensure the safe operation of the server system, and provide flexible notification mechanism to enable the syst ...

Posted on Wed, 01 Jan 2020 09:42:24 -0800 by phoenixx

Introduction to Docker containerization Technology (VIII) Docker backup and migration

1 container saved as image To view the image, you can find a new local image by saving the container as a mirror with the following command docker commit container name name of the new image saved docker commit th_centos th_centos_back2 [root@bogon home]# docker commit th_centos th_centos_back2 sha256:07198478ead6dea1a31212 ...

Posted on Wed, 01 Jan 2020 02:04:52 -0800 by phpian