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.
Posted on Thu, 02 Jan 2020 07:06:04 -0800 by Kev0121
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
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
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
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?
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
Installation environment and software version:
Database version: mysql-5.7.20-linux-glibc2.12-x86 ʄ
Hard disk: 100G
1. Upload the installation package mysql-5.7.20-linux-glibc2.1 ...
Posted on Wed, 01 Jan 2020 11:39:51 -0800 by AnotherQuestion
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:
Posted on Wed, 01 Jan 2020 10:20:05 -0800 by lehara
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
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
Posted on Wed, 01 Jan 2020 02:04:52 -0800 by phpian